#DIV/0! instead of total

  • Thread starter Thread starter Melinda
  • Start date Start date
M

Melinda

I have a worksheet I am adding the numbers to daily for
calculations. Rather than showing the correct amount at
the column on the end which averages the numbers I add
daily, it only shows #DIV/0!. The number does work when
every day of the month is filled out.

It also shows this in places where it is awaiting numbers
to finish the calculation. How do I rememdy this?


Thanks!
Melinda
 
Hi
you may post the formula which results in this #DIV/0 error
a general way to prevent this is
=IF(N(A1)=0,"",B1/A1)
 
Without your posting your formulae, it's hard to make a specific
suggestion, but in general, if your formula now is

=A1/B1

you should use something like

=IF(B1=0,"",A1/B1)

Your Average cell may be passing along the #DIV/0 errors, or may have a
division by zero itself if there are no numeric entries in the range.
Note that Average ignores text values.
 
You can change the formulas that return the div error, i.e.

=IF(C3=0,"",A3/C3)

or you can use

=SUMIF(D5:D100,"<>#DIV/0!")

which says sum everything except div errors while any other formula will
return the error
instead of the total. You might want to go with option 1 though and make
sure you don't get any
errors and then use a regular sum

=SUM(D5:D100)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top