Jacob, Bob, Dave ... Thank you all for supporting these boards ... there are
many fine solutions found here ... Kha
--
Kha


"Dave Peterson" wrote:

=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.


Ken wrote:

Excel2003 ...

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

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

Thanks ... Kha

--
Kha

--

Dave Peterson
.