SUM ... Numbers, Nulls "", & Div/0

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel2003 ...

Range (D3:D14) ... contains Numbers, Nulls "" & Div/0 ...

How do I write Formula to ... SUM the Numbers?

Thanks ... Kha
 
If the numbers are all positive numbers try
=SUMIF(D3:D15,">0")

OR else try the below array formula ..You create array formulas in the same
way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=SUM(IF(ISNUMBER(D3:D15),D3:D15))
 
=SUMIF(d3:d14,"<>"&"#Div/0!")
or
=SUMIF(d3:d14,"<>#Div/0!")

(I like the first since it's easier to see how the comparison string is built.
 
Jacob, Bob, Dave ... Thank you all for supporting these boards ... there are
many fine solutions found here ... Kha
 
Back
Top