Formula

D

Diane

I know how to hide the formula if it equals zero, however can I eliminate
those cells from the cell that gives me a SUM with division in the formula?
I get the error code of #DIV/0!
 
D

Duke Carey

You can eliminate the errors by using a formula like:

=IF(A5=0,"NA",B5/A5)

The SUM() won't generate errors in that case
 
M

Mike H

Diane,

It's better to eliminate the error by checking if the divisor is zero but to
sum with those errors in the range try

=SUMIF(A1:A12,">"&0)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Options for DIV#/0 6
Supress DIV/0 2
Logical Test 5
How to not get '0' or '#DIV/0!' in a cell with a percentage formul 5
what IF - formula question 4
HELP please... easy function 2
aauugghhh...#div/o problems & various average formula problems 5
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0

Top