Help with SUMPRODUCT and AND Logic

Occasional Visitor

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:

  1. Of Cost * Units Sold (column C and D), where
  2. Units Sold is > 60, AND
  3. Rating (column B) is "A"

Thanks

 

1 Reply

@rr27680 

=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.

sumproduct.JPG