software

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

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,quot;quot;)

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

In article gt;,
Pieman gt; wrote:

gt; Hi
gt;
gt; I have a worksheet that records the result of a customer satisfaction survey
gt; we carry out each time a customer buys from us.
gt;
gt; Each score is recorded as points out of a maximum of 90 with ten score
gt; columns (C4-C14) on the worksheet. I have another cell (C3) which I need to
gt; display the total score so far for that customer as a percentage figure.
gt;
gt; So I need C3 to display a total of all the scores entered as a percentage of
gt; the maximum possible score. The problem i've had is getting the formula to
gt; only count the score cells that have a value entered.
gt;
gt; Any ideas would be much appreciated.
gt;
gt; Thanks
gt; Simon