This shouldn't be too diffacult but I can't seem to find the function that
would allow me to sum the cells with numbers and then divide that by the
number of blank cells.
e.g. cells A1:A5, if A1 is 5, A2 is 10 and cells A3 through A5 are blank
then the answer would be 5. 5+10/3=5
I tried isnumber and isblank but that doesn't work. Any ideas?

What result do you want if all the cells contain numbers?

Biff

"mmcap" wrote in message
...
This shouldn't be too diffacult but I can't seem to find the function that
would allow me to sum the cells with numbers and then divide that by the
number of blank cells.
e.g. cells A1:A5, if A1 is 5, A2 is 10 and cells A3 through A5 are blank
then the answer would be 5. 5+10/3=5
I tried isnumber and isblank but that doesn't work. Any ideas?

A play using COUNTBLANK might suffice:
=IF(COUNTBLANK(A1:A5)=0,"",SUM(A1:A5)/COUNTBLANK(A1:A5))
If there's no blank cells, it'll return a blank: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mmcap" wrote:
This shouldn't be too difficult but I can't seem to find the function that
would allow me to sum the cells with numbers and then divide that by the
number of blank cells.
e.g. cells A1:A5, if A1 is 5, A2 is 10 and cells A3 through A5 are blank
then the answer would be 5. 5+10/3=5
I tried isnumber and isblank but that doesn't work. Any ideas?

Hi

Assuming you just want the sum of the numbers if there are no blanks in
the range, then one way would be
=SUM(A1:A5)/MAX(1,COUNTIF(A1:A5,""))

--
Regards

Roger Govier


"mmcap" wrote in message
...
This shouldn't be too diffacult but I can't seem to find the function
that
would allow me to sum the cells with numbers and then divide that by
the
number of blank cells.
e.g. cells A1:A5, if A1 is 5, A2 is 10 and cells A3 through A5 are
blank
then the answer would be 5. 5+10/3=5
I tried isnumber and isblank but that doesn't work. Any ideas?