Counting on multiple criteria

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Supplier Unsatisfactory Satisfactory Good Very Good Excellent
Red
Blue
Yellow

I have a table similar to that above and need to count the supplier
evaluation rating for a number of suppliers

Supplier names are in range D2:D2001 and their evaluation rating in J2:J2001

For example i need to count all the unsatisfactory's for supplier 'red'.
This is then repeated for all suppliers and all categories (satisfactory,
good etc).

Can you help?

Thanks
Craig
 
=SUMPRODUCT((D2:D2001="Red")*(J2:J2001="Good")) and then adapt this for the
other cases.
 
sumproduct might be the best function to use as Gary recommend, but you also
can use Countif function.
Countif(J2:J2001, A2:A2001="red")
Adopt the formula for othe evaluation criteria.
 
Back
Top