#DIV/0! query

[Brento]

Hi All,

Could anyone please help me to fix this problem. I am trying to sum
row of data but because it has a DIV/0 cell it will not add the data.

The DIV/0 is a cell with a simle formula awaiting data to be added at
later date.

Is there any way to add the data and exclude to div/0 cells but no
manaully write a formula suming individual cells?

Any sudgestion would be greatly and urgently appreciated.

Thanks
Bren

 

[Domenic]

Try...

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

....or you could change the formula to return a blank "" instead of
#DIV/0!.

Hope this helps!