I'm tallying results from a survey. For the sake of making this less complicated, say there are 2 questions and 5 surveys were submitted with answers to each of the 2 questions. Questions are answered on a scale of 0-5.

Column A
Will have one of "M", "S", "G" or "L" which is what I'm using to split up survey results by demographic.

Columns B, C
Are questions. Will have scores of 0-5 in the cells.

G4
5

F4
4

E4
3

D4
2

C4
1

B4
0
Now, I'm using this
=IF(AND(COUNTIF(A2:A6,$G$4),COUNTIF(A2:A6,$G$4)=COUNTIF(A2:A6,$G$4)),COUNTIF(A2:A6,$G$4),"-")

to tally the number of times the score 5 shows up and so on.

How do I do this for each M, S, G, L though?

Thanks for any help on this! I can provide a sample if it will help.