Use Countif, as in:
=countif(a:a,1)

Regards,
Fred.

"Patsy" wrote in message
...
I am working on a spread sheet that I built from a survey. In one of the
columns I have various numbers (1, 2, 3, 4, etc.) to define the answers to
a
questions. There are approximately 75 responses.Example: 1 = don't know
right
now, 2= have a clue, 3= still learning, etc.
How can I write the formula that will say I have 20 responses for 1, 15
responses for 2, etc. per column?