divide by 0 error jmp
 

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?

divide by 0 error jmp
 

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

"JohnnyJomp" wrote:

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?

divide by 0 error jmp
 

Hi Mike!
thanks for the tips!
John

"Mike H" wrote:

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

"JohnnyJomp" wrote:

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?