If I understand you correctly you are attempting to perform a mathematical
function on cells that are in themselves outputs of other formulas. In some
instances those formulas output a #DIV/0.

Use the ISERROR function combined with an IF statement to erase #DVI/0's.
They won't display anymore and formulas that include cells that formerly
evaluated to #DIV/0 will now calculate correctly...

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