Forum Discussion
Help with SUMPRODUCT and AND Logic
Hello, I am stuck with using the SUMPRODUCT function with the AND logic, here is the http://SUMPRODUCT%20- AND What I am trying to do is, do a SUMPRODUCT: Of Cost * Units Sold (column C and...
=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.