Forum Discussion
xlookup
Hi All I am really new to this so apologize but i am trying to add up a list of values based on 3 criteria's using the below formula and it is returning a value error but if i take out the 3 criteri...
How about
=SUMPRODUCT((Apr!$N$2:$AG$2=Sheet1!A2)*(Apr!$N$4:$AG$4=Sheet1!$F$1)*(TRANSPOSE(Apr!$K$5:$K$24)=Sheet1!E2),Apr!$N$5:$AG$22)
Try this then:
=SUMPRODUCT((Apr!$N$2:$AG$2=Sheet1!A2)*(Apr!$N$4:$AG$4=Sheet1!$F$1)*(Apr!$K$5:$K$24=Sheet1!E2),Apr!$N$5:$AG$24)
Please note that I used Apr!$N$5:$AG$24 to match the size of Apr!$K$5:$K$24
