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?

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?

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?

With the below data in Col A and B. try the formula in D1 as shown below
...and copy down..

Col A Col B Col C Col D
Que 1 1 1 =COUNTIF(B:B,C1)
Que 2 2 2 2
Que 3 3 3 2
Que 4 4 4 2
Que 5 1 5 0
Que 6 2
Que 7 3
Que 8 4
Que 9 1
Que 10 1
Que 11 1


If this post helps click Yes
---------------
Jacob Skaria


"Robin" wrote:

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?