Forum Discussion
rr27680
Nov 09, 2022Copper Contributor
Help with SUMPRODUCT and AND Logic
Hello,
I am stuck with using the SUMPRODUCT function with the AND logic, here is the data sheet.
What I am trying to do is, do a SUMPRODUCT:
- Of Cost * Units Sold (column C and D), where
- Units Sold is > 60, AND
- Rating (column B) is "A"
Thanks
- OliverScheurichGold Contributor
=SUMPRODUCT(($B$2:$B$11=F2)*($C$2:$D$11>60)*$C$2:$D$11)
I can't open your data sheet but maybe it's similar to this example.