AVERAGE around a #Div/0 error?
 

Excel2003 ... I have 10 WorkBooks ... WorkBook 10 is a Summary of WorkBooks 1-9

In WorkBook 10 I have an AVERAGE formula linking back to the other 9
WorkBooks.

So far Link & Formula are working fine in WorkBook 10 with excepiton of
#Div/0 error which is preventing a SUM(myrange) Formula from working.

I can't use =if(iserror(myformula),"",myformula) because my Formula is too
long.

So ... is there some simple way to SUM a Range & ignore the #Div/0 error?

Thanks ... Kha

AVERAGE around a #Div/0 error?
 

Trap the #Div/0 error in the source.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Ken" wrote:

Excel2003 ... I have 10 WorkBooks ... WorkBook 10 is a Summary of WorkBooks 1-9

In WorkBook 10 I have an AVERAGE formula linking back to the other 9
WorkBooks.

So far Link & Formula are working fine in WorkBook 10 with excepiton of
#Div/0 error which is preventing a SUM(myrange) Formula from working.

I can't use =if(iserror(myformula),"",myformula) because my Formula is too
long.

So ... is there some simple way to SUM a Range & ignore the #Div/0 error?

Thanks ... Kha

AVERAGE around a #Div/0 error?
 

Best way would be to eliminate the error by using something like

=IF(C2=0,0,A2/C2)

since the error derives from dividing by zero

However this will work

=SUMIF(A1:A10,"<#DIV/0!")


--
Regards,

Peo Sjoblom

"Ken" wrote in message
...
Excel2003 ... I have 10 WorkBooks ... WorkBook 10 is a Summary of
WorkBooks 1-9

In WorkBook 10 I have an AVERAGE formula linking back to the other 9
WorkBooks.

So far Link & Formula are working fine in WorkBook 10 with excepiton of
#Div/0 error which is preventing a SUM(myrange) Formula from working.

I can't use =if(iserror(myformula),"",myformula) because my Formula is too
long.

So ... is there some simple way to SUM a Range & ignore the #Div/0 error?

Thanks ... Kha