Hi,

You may also use a pivot table.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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?