Thread: SUM ... Numbers, Nulls "", & Div/0
View Single Post
  #3  
Old April 30th, 2010, 01:39 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
  
Posts: 489
Default SUM ... Numbers, Nulls "", & Div/0
Try this array formula

=SUM(IF(ISNUMBER(D314),D314))

--

HTH

Bob

"Ken" wrote in message
news
Excel2003 ...

Range (D314) ... contains Numbers, Nulls "" & Div/0 ...

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

Thanks ... Kha

--
Kha