Forum Discussion
Is it possible to nest filter inside of sumif?
Office 365 without Lamda functionality I have a large data set (1000+ rows with 100+ columns) Below screen shot is a scaled-down version of the data set but I think it serves a good example. ...
If I understand correctly, I think this is one way you could do it.
=SUM(IFERROR(NUMBERVALUE(Table1),0)*MMULT((Table1[Year]=A38)*(Table1[Text1]=$B$23:$C$23),--(TRANSPOSE(COLUMN($B$23:$C$23)>0)))*TRANSPOSE(MMULT(--(TRANSPOSE(Table1[#Headers])=$B$24:$C$24),--(TRANSPOSE(COLUMN($B$24:$C$24)>0)))))