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?