Need a total count for various numbers in a column
 

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?

Need a total count for various numbers in a column
 

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?

Need a total count for various numbers in a column
 

Suppose your various numbers are in column C (Row 1 for headings)
Then in C77 enter =COUNTIF(C2:C75,1)&" responses for 1"&COUNTIF(C2:C75,2)&"
responses for 2" etc. Copy across to other columns.

"Patsy" wrote:

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?

Need a total count for various numbers in a column
 

Hi Patsy,
Let's say your information is in column A , in first row of every column
enter the numbers 1 (Column B), 2 (Column C), etx
Then in the row below in column B enter
=COUNTIF(A:A,B1)

if you are not using excel 2007 use

=COUNTIF(A1:A100,B1)

copy the formula given above to the other columns

"Patsy" wrote:

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?

Need a total count for various numbers in a column
 

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?