M Max Sep 20, 2004 #2 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)
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 Sep 20, 2004 #3 Hi I would prevent the #DIV/0 errors with a formula such as =IF(N(B1)=0,"",A1/B1)
A Aladin Akyurek Sep 20, 2004 #4 =SUMIF(Range,"<>#DIV/0!") or try to prevent the occurrence of the error in the range of interest.
