Help with SUMPRODUCT and AND Logic

Occasional Visitor



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"



1 Reply



I can't open your data sheet but maybe it's similar to this example.