Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting for multiple conditions
For the following list
Name Code Rating Jessica F 5 Cynthia A 3 John E 2 Brad I 4 Aaron G 5 I need to create a list showing Number of people by rating FOR GROUPS of Codes (so, for example, People A-E who are rated 5, People A-E rated 4, people H rated 5, etc - see below) Rating # of people 1 2 3 4 5 I used the following to group the people first, but now I can't figure out how to add in the rating.... =COUNTIF($D$3:$D$31,"A")+(COUNTIF($D$3:$D$31,"B")) +(COUNTIF($D$3:$D$31,"C"))+(COUNTIF($D$3:$D$31,"D" ))+(COUNTIF($D$3:$D$31,"E")) Help, please!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with counting multiple conditions | Excel Discussion (Misc queries) | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |