Hi All,
Just cannot figure out how to create a formula based on the following criteria
Criteria 1
Match $B2 with Data!$A$2:$A$175
Then Criteria 2
Match a range ---- (Data!$E$2:$E$175=">=11"),--(Data!$E$2:$E$175="<=20")
Then provide sum of (Data!$B$2:$D$175)
I am using
=SUMPRODUCT(----(Data!$A$2:$A$175=$B2),--(Data!$E$2:$E$175=">=11"),--(Data!$E$2:$E$175="<=20"),Data!$B$2:$D$175)
but getting #value, and its because, well, I don't know!!! .. not to good with Excel as it is!
Can someone help me please?
Cheers
Bookmarks