Counting for multiple conditions

  • Thread starter Thread starter J. Catz.
  • Start date Start date
J

J. Catz.

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!!
 
Thanks, teethless, but I'm still getting 0 as the value. This is what I
have now (played around a little). No matter what, I'm returning 0...

=SUMPRODUCT(($D$3:$D$31={"A","B","C","D","E"})*($E$3:$E$31=5)*(COUNT($C$3:$C$31)))

My chart is
Dept Name Grade Rating
 
Back
Top