Help with formula

R

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

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

Sandy Mann

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top