calculating percentage of who said

[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.

 

[mzehr]

Hi,
Try
=COUNTIF($C$2:$C$26,"=1")/COUNT($C$2:$C$26) to evaluate
for answer 1. Replace the "=1" with any other answer
possibilities. If the data gets more complex, you really
ought to have a look at pivot tables. See the following
sites for excellent help in this

http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/xlPivot02.html

HTH

 

[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

D1011 will return the percentages for "1" and "2"

 

[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