Percentage score formula

P

Pieman

Hi

I have a worksheet that records the result of a customer satisfaction survey
we carry out each time a customer buys from us.

Each score is recorded as points out of a maximum of 90 with ten score
columns (C4-C14) on the worksheet. I have another cell (C3) which I need to
display the total score so far for that customer as a percentage figure.

So I need C3 to display a total of all the scores entered as a percentage of
the maximum possible score. The problem i've had is getting the formula to
only count the score cells that have a value entered.

Any ideas would be much appreciated.

Thanks
Simon
 
J

JE McGimpsey

Assuming that you actually have 10 score cells (C4:C14 is 11 cells), and
that they're all weighted equally (9 points):

=AVERAGE(C4:C13)/9

or, to avoid a #DIV/0 error if no scores are entered:

=IF(COUNT(C4:C13),AVERAGE(C4:C13)/9,"")

in either case, format the calculated cell as a percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top