Adding a column with formulas (#DIV/0!) in column and getting num

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

I have entries that will have numbers and entrys that will have (#DIV/0!).
I wnat to get the numbers not the (#DIV/0!). in the total box.
 
You should trap the #DIV/0 results in those formulae. Iso merely doing a
straightforward division, add an IF clause, to change those values to 0.

Without any data to go on, let's say you are using a formula = A1/B1. Since
both of the two may have nothing in it, and since then , or if A1 contains
nothing, your formula would result in a #DIV/0 you could do one of the
following:

=IF(ISERROR(A1/B1),0,A1/B1)
=IF(OR(A1="",B1=""),0,A1/B1).

Having done that, you would not have to worry about #DIV/0's
 
Hi,

If you are trying to SUM a column that contains #DIV/0! errors then use the
following array formula:

=SUM(IF(ISERR(B2:B6),0,B2:B6))

To make it an array press Shift+Ctrl+Enter to enter it.

In 2007 you can use the array formula:

=SUM(IFERROR(B2:B6,))
 
Back
Top