Sum values with #DIV/0

M

Max

Smidt57 said:
How do I sum mulitple cells if one of the cells contains #DIV/0!
Click to expand...

One way ..

Instead of say in C4: =SUM(C1:C3)

Try in C4: =SUM(IF(NOT(ISERROR(C1:C3)),C1:C3))

Array-enter the formula in C4,
i.e. press CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
 
F

Frank Kabel

Hi
I would prevent the #DIV/0 errors with a formula such as
=IF(N(B1)=0,"",A1/B1)
 
A

Aladin Akyurek

=SUMIF(Range,"<>#DIV/0!")

or try to prevent the occurrence of the error in the range of interest.
 

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
zero denominator 4
dividing by 0 error 6
Averages formula/0 7
how to sum cells and ignore the #div/0! 's ? 2
Calculations resulting in #DIV/0! 6
Formula 2
#DIV/0! ERROR 2

Top