#DIV/0!

[Guest]

I've got a YTD spreadsheet that will be fed each month
from monthly spreadsheets... In some of the cells within
the monthly spreadsheets it is #DIV/0!... As the data is
fed in by the month Division by 0 is elimated, due to the
cells in the formula being fed numbers... What I want to
know is it possible in the year to date spread, to SUM a
row say SUM(A4:F4) with some of the cells containing
#DIV/0!??

Thanks
kevin

 

[Frank Kabel]

Hi
why not prevent the #DIV/0 errors with a fomula such as
=IF(N(A1)=0,"",B1/A1)