A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 01:33 PM posted to microsoft.public.excel.misc
Ken
external usenet poster
 
Posts: 954
Default SUM ... Numbers, Nulls "", & Div/0

Excel2003 ...

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

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

Thanks ... Kha

--
Kha
  #2  
Old April 30th, 2010, 01:39 PM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default SUM ... Numbers, Nulls "", & Div/0

If the numbers are all positive numbers try
=SUMIF(D315,"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(D315),D315))


--
Jacob (MVP - Excel)


"Ken" wrote:

Excel2003 ...

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

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

Thanks ... Kha

--
Kha

  #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



  #4  
Old April 30th, 2010, 02:07 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default SUM ... Numbers, Nulls "", & Div/0

=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 (D314) ... contains Numbers, Nulls "" & Div/0 ...

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

Thanks ... Kha

--
Kha


--

Dave Peterson
  #5  
Old April 30th, 2010, 03:36 PM posted to microsoft.public.excel.misc
Ken
external usenet poster
 
Posts: 954
Default SUM ... Numbers, Nulls "", & Div/0

Jacob ... Simple solution (when you know it) ... Thanks ... Kha
--
Kha


"Jacob Skaria" wrote:

If the numbers are all positive numbers try
=SUMIF(D315,"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(D315),D315))


--
Jacob (MVP - Excel)


"Ken" wrote:

Excel2003 ...

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

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

Thanks ... Kha

--
Kha

  #6  
Old April 30th, 2010, 03:41 PM posted to microsoft.public.excel.misc
Ken
external usenet poster
 
Posts: 954
Default SUM ... Numbers, Nulls "", & Div/0

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 (D314) ... contains Numbers, Nulls "" & Div/0 ...

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

Thanks ... Kha

--
Kha


--

Dave Peterson
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.