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.

--
R. Khoshravan
Please click "Yes" if it is helpful.


"Craig" wrote:

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