countif for survey results

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.

I typed up a lengthy and easy solution to this, but I now think that it is for Excel 2007, so I doubt it would help you now that I think about it. Let me know if you want it or get Excel 2007.


It involves using =COUNTIFS() instead of =COUNTIF()

=COUNTIFS() allows multiple criteria, while =COUNTIF() only allows one.

You'll have 2 criteria if you're looking for a total for all "M"s that answered "5" and so on, since this checks for 2 things: the demographic and the answer.


I have my lengthy explanation and an excel file example saved for if you would need it or can use it, let me know.