#DIV/0! query

  • Thread starter Thread starter Brento
  • Start date Start date
B

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
 
Try...

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

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

Hope this helps!
 
Back
Top