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