[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
--
Gary''s Student - gsnu200791


"Richard" wrote:

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

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

"Gary''s Student" wrote:

=AVERAGE(A1:C1)
This will automatically adjust for empty cells
--
Gary''s Student - gsnu200791


"Richard" wrote:

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

[Sandy Mann]

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Richard" wrote in message
...
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%

"Gary''s Student" wrote:

=AVERAGE(A1:C1)
This will automatically adjust for empty cells
--
Gary''s Student - gsnu200791


"Richard" wrote:

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