Can't Sum cell with #DIV/0!

  • Thread starter Thread starter Bradley
  • Start date Start date
B

Bradley

Hey all,
I'm trying to sum cells (linked to another sheet) but some have #DIV/0!
(no data) in some of the cells and my column won't total.

Help? Ideas?

TIA!

-b
 
Hi
so in this case you should try to prevent these errors :-)
e.g. if you have a formula like
=A1/B1
change this to
=IF(B1=0,"",A1/B1)
then SUM should work on this column
 
Frank said:
Hi
so in this case you should try to prevent these errors :-)
e.g. if you have a formula like
=A1/B1
change this to
=IF(B1=0,"",A1/B1)
then SUM should work on this column
Click to expand...
Thanks, I'll give it a try!

-b
 
Frank said:
Hi
so in this case you should try to prevent these errors :-)
e.g. if you have a formula like
=A1/B1
change this to
=IF(B1=0,"",A1/B1)
then SUM should work on this column
Click to expand...
Frank (or anyone),
I have more than one cell with #DIV/0! in it (I'm trying to sum 5 rows
across). How do I take that into account?

Here's what I'm doing. I have about a dozen sheets I'm totaling on one.
An example formula for a cell is:
=(TIME_SHT!P42 * 60) * 0.4 / TIME_SHT!AB42

This brings my numbers over, but some may be blank (thus the #DIV/0!).
How do I discount the #DIV/0! when totalling?

Thanks again!

-b
 
Hi
change the formula to
=IF(TIME_SHT!AB42=0,"",(TIME_SHT!P42 * 60) * 0.4 / TIME_SHT!AB42)
 
Back
Top