Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting on multiple criteria
=SUMPRODUCT((D2:D2001="Red")*(J2:J2001="Good")) and then adapt this for the
other cases. -- Gary''s Student - gsnu200830 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting using multiple criteria | Excel Discussion (Misc queries) | |||
Counting multiple criteria | Excel Worksheet Functions | |||
counting using multiple criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |