If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to sum cells and ignore the #div/0! 's ?
I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,"0") if I
initially have no data entered i get the #div/0! 's is there a fix for this? |
#2
|
|||
|
|||
how to sum cells and ignore the #div/0! 's ?
=IF(COUNTIF(C8:E8,"0")=0,"",SUM(C8:E8)/COUNTIF(C8:E8,"0"))
-- David Biddulph "Bryan" wrote in message ... I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,"0") if I initially have no data entered i get the #div/0! 's is there a fix for this? |
#3
|
|||
|
|||
how to sum cells and ignore the #div/0! 's ?
Hi,
=IF(COUNT(C8:E8)0,SUM(C8:E8)/COUNTIF(C8:E8,"0"),"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bryan" wrote: I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,"0") if I initially have no data entered i get the #div/0! 's is there a fix for this? |
#4
|
|||
|
|||
how to sum cells and ignore the #div/0! 's ?
=IF(COUNT(C8:E8)0,SUM(C8:E8)/COUNTIF(C8:E8,"0"),"")
your formula fail if C8: 0, D8: blank, C8: blank, or all 0s or 0,0, blank Robust formula: =IF(COUNTIF(C8:E8,"0"),SUM(C8:E8)/COUNTIF(C8:E8,"0"),"") "Mike H" wrote: Hi, =IF(COUNT(C8:E8)0,SUM(C8:E8)/COUNTIF(C8:E8,"0"),"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bryan" wrote: I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,"0") if I initially have no data entered i get the #div/0! 's is there a fix for this? |
Thread Tools | |
Display Modes | |
|
|