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

Supress DIV/0 2
Copy addition formula of non-consecutive horizontal cells 2
Cumulative formula for word table 0
Options for DIV#/0 6
How to not get '0' or '#DIV/0!' in a cell with a percentage formul 6
HELP please... easy function 3
Use TODAY() function as the criteria in a SUMIF formula 1
Using SUM(INDIRECT()) 2

Top