Forum Discussion

rr27680's avatar
rr27680
Copper Contributor
Nov 09, 2022

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:

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

Thanks

 

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

     

Resources