Percentage score formula

[Guest]

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

 

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