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.