Formula

  • Thread starter Thread starter Diane
  • Start date Start date
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!
 
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
 
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
dividing by 0 error 6
Supress DIV/0 2
How to not get '0' or '#DIV/0!' in a cell with a percentage formul 5
aauugghhh...#div/o problems & various average formula problems 5
HELP please... easy function 2
what IF - formula question 4
IF Function error #VALUE 2

Back
Top