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