Help with formula

[Richard]

I need to return a percentage in D1. My problem is. There may be nothing in
one or all the cells but I still need a percentage. I'm using =(A1+B1+C1)/3
if there is something in all 3 cells, but if there is nothing in say A1 I
have to use =(A1+B1+C1)/2 and so on. I keep having to change the formula each
time depending on if there is something or nothing in each cell. Thanks in
Advance!!!

 

[Gary''s Student]

=AVERAGE(A1:C1)
This will automatically adjust for empty cells

 

[Richard]

Thanks for your help! But I don't think I'm getting the results I need.
Example: These are the results I need.

100.00% 10.00% 10.00% 40.00%
100.00% 10.00% 55.00%
100.00% 100.00%

 

[Sandy Mann]

=SUM(A1:C1)/COUNT(A1:C1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk