Any chance you could change the formulas in the referenced cells to have an
if(dividend = 0,"",divisor/dividend)?

That would remove the #div/0 errors and allow the average formula to skip
your errored cell... Not sure the formula wil calc otherwise.

"Jacob" wrote:

I am trying to find the average of cells if one or more of the cells has
#DIV/0!
Example: =average(Page1B1:Page2B1:Page3B1) Page 2B1 has #DIV/0! in the cell
because nothing has been entered in another cell where it captures its
information. So all I would need is the average of (Page1B1 and Page3B1).
The cell which shows #DIV/0! is subject to change all the time. Does this
make sense??!!

I am trying to do the same thing here is my formula how would i add yours to
it?
=SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)

"Sean Timmons" wrote:

Any chance you could change the formulas in the referenced cells to have an
if(dividend = 0,"",divisor/dividend)?

That would remove the #div/0 errors and allow the average formula to skip
your errored cell... Not sure the formula wil calc otherwise.

"Jacob" wrote:

I am trying to find the average of cells if one or more of the cells has
#DIV/0!
Example: =average(Page1B1:Page2B1:Page3B1) Page 2B1 has #DIV/0! in the cell
because nothing has been entered in another cell where it captures its
information. So all I would need is the average of (Page1B1 and Page3B1).
The cell which shows #DIV/0! is subject to change all the time. Does this
make sense??!!

As pointed out in your other thread, you need to sort out your mismatched
parentheses before you go any further.
--
David Biddulph

"Matt" wrote in message
...
I am trying to do the same thing here is my formula how would i add yours
to
it?
=SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)

"Sean Timmons" wrote:

Any chance you could change the formulas in the referenced cells to have
an
if(dividend = 0,"",divisor/dividend)?

That would remove the #div/0 errors and allow the average formula to skip
your errored cell... Not sure the formula wil calc otherwise.

"Jacob" wrote:

I am trying to find the average of cells if one or more of the cells
has
#DIV/0!
Example: =average(Page1B1:Page2B1:Page3B1) Page 2B1 has #DIV/0! in the
cell
because nothing has been entered in another cell where it captures its
information. So all I would need is the average of (Page1B1 and
Page3B1).
The cell which shows #DIV/0! is subject to change all the time. Does
this
make sense??!!