The SumIf formula sums those values that meet your criteria. You don't want
to sum them, you want to count them. Use the CountIf formula. HTH Otto
"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?