Percentage Formula

[Jessica]

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.

 

[Gord Dibben]

=11/51 formatted to percentage?


Gord Dibben MS Excel MVP

 

[Pete_UK]

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