=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