Did you try COUNTif
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robin" wrote in message
...
I'm trying to count the values in a column and thought the sumif formula
would work and it's not. For example, I have values from 1-5 in answers
to
survey questions and would like to count how many 1's, how many 2's, etc.
Can anyone help?