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!!

=SUMPRODUCT((Code={"A","B","C","D","E"})*(Rating=E 1))


"J. Catz." wrote:

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





"Teethless mama" wrote:

=SUMPRODUCT((Code={"A","B","C","D","E"})*(Rating=E 1))


"J. Catz." wrote:

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!!