Hi,

I have a spreadsheet where column A is a list of questions, B is yes, C is
no, D is N/A and E is no answer. I had 51 people answering those questions.
for example 11 people out of the 51 answer yes to question 1. I need a
formula that would calculate the percentage, instead of me just typing 11
under column B.

=11/51 formatted to percentage?


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 11:11:02 -0700, Jessica
wrote:

Hi,

I have a spreadsheet where column A is a list of questions, B is yes, C is
no, D is N/A and E is no answer. I had 51 people answering those questions.
for example 11 people out of the 51 answer yes to question 1. I need a
formula that would calculate the percentage, instead of me just typing 11
under column B.

So how would Excel know that there were 11 Yes answers if you don't
type the figure in?

Put the numbers in columns B to E as you describe, then in F2 you can
enter this formula:

=B2/SUM($B2:$E2)

Format this cell as percentage, and then copy across into G2:i2. Then
copy F2:i2 down to cover your 51 questions. You can then hide columns
B to E if you only want to see the percentage values.

Hope this helps.

Pete

On May 13, 7:11*pm, Jessica wrote:
Hi,

I have a spreadsheet where column A is a list of questions, B is yes, C is
no, D is N/A and E is no answer. I had 51 people answering those questions..
for example 11 people out of the 51 answer yes to question 1. I need a
formula that would calculate the percentage, instead of me just typing 11
under column B.

=COUNTA(B1:B100)/COUNTA(A1:A100) and format as percentage.
--
David Biddulph

"Jessica" wrote in message
...
Hi,

I have a spreadsheet where column A is a list of questions, B is yes, C is
no, D is N/A and E is no answer. I had 51 people answering those
questions.
for example 11 people out of the 51 answer yes to question 1. I need a
formula that would calculate the percentage, instead of me just typing 11
under column B.