#DIV/0! query
 

Hi All,

Could anyone please help me to fix this problem. I am trying to sum a
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 a
later date.

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

Any sudgestion would be greatly and urgently appreciated.

Thanks
Brent


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=507003

#DIV/0! query
 

Try...

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

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

Hope this helps!

In article ,
Brento wrote:

Hi All,

Could anyone please help me to fix this problem. I am trying to sum a
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 a
later date.

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

Any sudgestion would be greatly and urgently appreciated.

Thanks
Brent