Counting on multiple criteria

[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 D22001 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

 

[Gary''s Student]

=SUMPRODUCT((D22001="Red")*(J2:J2001="Good")) and then adapt this for the
other cases.

 

[Khoshravan]

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.