divide by 0 error jmp

  • Thread starter Thread starter JohnnyJomp
  • Start date Start date
J

JohnnyJomp

Hi!
I have a spreadsheet where if certain cells are empty, I get a divide by 0
errors. I understand I can nopt divide by 0; that is not the issue. My issue
is I can not seem to add a column of numbers if one or more have divide by 0
errors.
Can someone suggest how I can either get rid of the divide/0 error, or be
able to add a selection of cells where 1 or more have /0 errors?
 
Hi the choice is your:-

To sume a range with div/0 in use
=SUMIF(A1:A10,"<>#DIV/0!")

To eliminate div/o use
=IF(ISERROR(9/C6),"",9/C6)
In this case 9/c6 generates a Div/0 error

Mike
 
Hi Mike!
thanks for the tips!
John

Mike H said:
Hi the choice is your:-

To sume a range with div/0 in use
=SUMIF(A1:A10,"<>#DIV/0!")

To eliminate div/o use
=IF(ISERROR(9/C6),"",9/C6)
In this case 9/c6 generates a Div/0 error

Mike
Click to expand...
 
Back
Top