Counting on multiple criteria
 

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

Counting on multiple criteria
 

=SUMPRODUCT((D2:D2001="Red")*(J2:J2001="Good")) and then adapt this for the
other cases.
--
Gary''s Student - gsnu200830

Counting on multiple criteria
 

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