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