calculating percentage of who said

N

Nancy Cunningham

I am entering responses from a survey. How do I make Excel
97 calculate the percentage of the number who said X? For
instance, I have 25 surveys and I want to know the
percentage of people who answered 1 to question A and the
percentage who answered 2 to question A. Column C of my
document looks like this. C
A
2
2
1
2
1
1
2
Thanks a million to anyone who knows this.
 
M

Max

One way:

The range for responses to Question A is in C2:C8

List the possible answers in say: C10:C11, viz.:
put in C10: 1, in C11: 2

Put in D10:

=COUNTIF($C$2:$C$8,C10)/COUNT($C$2:$C$8)

Format D10 as percentage

Copy D10 down to D11

D10:D11 will return the percentages for "1" and "2"
 
C

Charlie

Nancy,

One way is to enter =COUNTIF(C2:C8,2)/COUNT(C2:C8) will
give the percent of answer 2 and =COUNTIF(C2:C8,1)/COUNT
(C2:C8)the percent of answer 1. Format the cells to
percent.

Charlie O'Neill
 
Top