LinkBack URL
About LinkBacks
sable 
How exactly is your formula counting the number of 5's
Shouldn't =Countif(A2:A6,G4) do it?
How exactly is your formula counting the number of 5's
Shouldn't =Countif(A2:A6,G4) do it?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks