how to add up columns with #DIV/0! in it

[Marq]

I have a column with totals in it, but some of the cells have the #DIV/0! in them...which prevents me from getting a total in the cell that sums up the column.

Is there a formula that I can use that will allow me to sum up entire column and disregaurd the #DIV/0! ????

 

[Domski]

You can use a formula like this:

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

Hope it helps.

 

[Marq]

works perfect..thanx!!

 

[Brian from Maui]

I have a column with totals in it, but some of the cells have the #DIV/0! in them...which prevents me from getting a total in the cell that sums up the column.

Is there a formula that I can use that will allow me to sum up entire column and disregaurd the #DIV/0! ????

Consider "fixing" the #DIV/0! error.....