It almost seems crazy to me that I'm missing this, but I am missing something
here. I have a large formula that I do not want to have to start over and do
a manual cell selection with (I think I realize I could have eliminated this
by holding down CTRL when I did the range, but that's an aside for now [and
please correct me if that is wrong too]).

THis is for Excel 2007/Enterprise

The formula is meant to be something like in the post title, i.e.:
=SUM(B2:B9)+B15+(B19:B44)+B90

but of course that gives me an error (#value).

I've tried the formula w/o any parenthesis
=B2:B9+B15+B19:B44+B90
(also the above w/a SUM in it)

with parenthesis as in the first example,
and as
=SUM([B2:B9]+B15+[B19:B44]+B90)
where the inside parentheses (currently "[]") were regular parentheses "()"
and the square ones. None worked so I went back to ()'s.

None of these have worked - could someone please share with me what I'm
doing incorrectly? It's a simple column of multiple debit entries into an
account, and we're trying to select only pertinent values.

I'll paste the LOOOOONG formula here for your review as well - thank you in
advance for your help!

Regards,
T.



=SUM((E52:E55)+(E57:E59)+E77+E116+E120+E121+(E125: E133)+E166+E167+E169+(E188:E192)+(E229:E231)+(E232 :E233)+(E243:E244)+(E350:E351)+(E400:E461)+(E467:E 469)+(E520:E523)+(E525:E527)+(E534:E537)+E587+E602 +(E604:E606)+E641+E643+E701+E717+(E728:E729)+E749+ (E764:E768)+(E816:E821)+E823+(E826:E827)+E912+E915 +(E965:E967)+(E978:E980)+(E997:E1018)+(E1200:E1213 )+(E1220:E1239)+(E1262:E1273)+(E1283:E1287)+(E1325 :E1326)+(E1332:E1333)+(E1335:E1346)+(E1398:E1593))

If you're using Excel 2007 you can have up to 255 arguments inside the SUM
function.

Try it like this:

=SUM(B2:B9,B15,B19:B44,B90)


--
Biff
Microsoft Excel MVP


"T. Otten" wrote in message
...
It almost seems crazy to me that I'm missing this, but I am missing
something
here. I have a large formula that I do not want to have to start over and
do
a manual cell selection with (I think I realize I could have eliminated
this
by holding down CTRL when I did the range, but that's an aside for now
[and
please correct me if that is wrong too]).

THis is for Excel 2007/Enterprise

The formula is meant to be something like in the post title, i.e.:
=SUM(B2:B9)+B15+(B19:B44)+B90

but of course that gives me an error (#value).

I've tried the formula w/o any parenthesis
=B2:B9+B15+B19:B44+B90
(also the above w/a SUM in it)

with parenthesis as in the first example,
and as
=SUM([B2:B9]+B15+[B19:B44]+B90)
where the inside parentheses (currently "[]") were regular parentheses
"()"
and the square ones. None worked so I went back to ()'s.

None of these have worked - could someone please share with me what I'm
doing incorrectly? It's a simple column of multiple debit entries into an
account, and we're trying to select only pertinent values.

I'll paste the LOOOOONG formula here for your review as well - thank you
in
advance for your help!

Regards,
T.



=SUM((E52:E55)+(E57:E59)+E77+E116+E120+E121+(E125: E133)+E166+E167+E169+(E188:E192)+(E229:E231)+(E232 :E233)+(E243:E244)+(E350:E351)+(E400:E461)+(E467:E 469)+(E520:E523)+(E525:E527)+(E534:E537)+E587+E602 +(E604:E606)+E641+E643+E701+E717+(E728:E729)+E749+ (E764:E768)+(E816:E821)+E823+(E826:E827)+E912+E915 +(E965:E967)+(E978:E980)+(E997:E1018)+(E1200:E1213 )+(E1220:E1239)+(E1262:E1273)+(E1283:E1287)+(E1325 :E1326)+(E1332:E1333)+(E1335:E1346)+(E1398:E1593))

Perfect, that did it, thank you!



"T. Valko" wrote:

If you're using Excel 2007 you can have up to 255 arguments inside the SUM
function.

Try it like this:

=SUM(B2:B9,B15,B19:B44,B90)


--
Biff
Microsoft Excel MVP


"T. Otten" wrote in message
...
It almost seems crazy to me that I'm missing this, but I am missing
something
here. I have a large formula that I do not want to have to start over and
do
a manual cell selection with (I think I realize I could have eliminated
this
by holding down CTRL when I did the range, but that's an aside for now
[and
please correct me if that is wrong too]).

THis is for Excel 2007/Enterprise

The formula is meant to be something like in the post title, i.e.:
=SUM(B2:B9)+B15+(B19:B44)+B90

but of course that gives me an error (#value).

I've tried the formula w/o any parenthesis
=B2:B9+B15+B19:B44+B90
(also the above w/a SUM in it)

with parenthesis as in the first example,
and as
=SUM([B2:B9]+B15+[B19:B44]+B90)
where the inside parentheses (currently "[]") were regular parentheses
"()"
and the square ones. None worked so I went back to ()'s.

None of these have worked - could someone please share with me what I'm
doing incorrectly? It's a simple column of multiple debit entries into an
account, and we're trying to select only pertinent values.

I'll paste the LOOOOONG formula here for your review as well - thank you
in
advance for your help!

Regards,
T.



=SUM((E52:E55)+(E57:E59)+E77+E116+E120+E121+(E125: E133)+E166+E167+E169+(E188:E192)+(E229:E231)+(E232 :E233)+(E243:E244)+(E350:E351)+(E400:E461)+(E467:E 469)+(E520:E523)+(E525:E527)+(E534:E537)+E587+E602 +(E604:E606)+E641+E643+E701+E717+(E728:E729)+E749+ (E764:E768)+(E816:E821)+E823+(E826:E827)+E912+E915 +(E965:E967)+(E978:E980)+(E997:E1018)+(E1200:E1213 )+(E1220:E1239)+(E1262:E1273)+(E1283:E1287)+(E1325 :E1326)+(E1332:E1333)+(E1335:E1346)+(E1398:E1593))

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"T. Otten" wrote in message
...
Perfect, that did it, thank you!



"T. Valko" wrote:

If you're using Excel 2007 you can have up to 255 arguments inside the
SUM
function.

Try it like this:

=SUM(B2:B9,B15,B19:B44,B90)


--
Biff
Microsoft Excel MVP


"T. Otten" wrote in message
...
It almost seems crazy to me that I'm missing this, but I am missing
something
here. I have a large formula that I do not want to have to start over
and
do
a manual cell selection with (I think I realize I could have eliminated
this
by holding down CTRL when I did the range, but that's an aside for now
[and
please correct me if that is wrong too]).

THis is for Excel 2007/Enterprise

The formula is meant to be something like in the post title, i.e.:
=SUM(B2:B9)+B15+(B19:B44)+B90

but of course that gives me an error (#value).

I've tried the formula w/o any parenthesis
=B2:B9+B15+B19:B44+B90
(also the above w/a SUM in it)

with parenthesis as in the first example,
and as
=SUM([B2:B9]+B15+[B19:B44]+B90)
where the inside parentheses (currently "[]") were regular parentheses
"()"
and the square ones. None worked so I went back to ()'s.

None of these have worked - could someone please share with me what I'm
doing incorrectly? It's a simple column of multiple debit entries into
an
account, and we're trying to select only pertinent values.

I'll paste the LOOOOONG formula here for your review as well - thank
you
in
advance for your help!

Regards,
T.



=SUM((E52:E55)+(E57:E59)+E77+E116+E120+E121+(E125: E133)+E166+E167+E169+(E188:E192)+(E229:E231)+(E232 :E233)+(E243:E244)+(E350:E351)+(E400:E461)+(E467:E 469)+(E520:E523)+(E525:E527)+(E534:E537)+E587+E602 +(E604:E606)+E641+E643+E701+E717+(E728:E729)+E749+ (E764:E768)+(E816:E821)+E823+(E826:E827)+E912+E915 +(E965:E967)+(E978:E980)+(E997:E1018)+(E1200:E1213 )+(E1220:E1239)+(E1262:E1273)+(E1283:E1287)+(E1325 :E1326)+(E1332:E1333)+(E1335:E1346)+(E1398:E1593))

try this idea
=SUM(I1:I3,L1,N1:N4,x22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"T. Otten" wrote in message
...
It almost seems crazy to me that I'm missing this, but I am missing
something
here. I have a large formula that I do not want to have to start over and
do
a manual cell selection with (I think I realize I could have eliminated
this
by holding down CTRL when I did the range, but that's an aside for now
[and
please correct me if that is wrong too]).

THis is for Excel 2007/Enterprise

The formula is meant to be something like in the post title, i.e.:
=SUM(B2:B9)+B15+(B19:B44)+B90

but of course that gives me an error (#value).

I've tried the formula w/o any parenthesis
=B2:B9+B15+B19:B44+B90
(also the above w/a SUM in it)

with parenthesis as in the first example,
and as
=SUM([B2:B9]+B15+[B19:B44]+B90)
where the inside parentheses (currently "[]") were regular parentheses
"()"
and the square ones. None worked so I went back to ()'s.

None of these have worked - could someone please share with me what I'm
doing incorrectly? It's a simple column of multiple debit entries into an
account, and we're trying to select only pertinent values.

I'll paste the LOOOOONG formula here for your review as well - thank you
in
advance for your help!

Regards,
T.



=SUM((E52:E55)+(E57:E59)+E77+E116+E120+E121+(E125: E133)+E166+E167+E169+(E188:E192)+(E229:E231)+(E232 :E233)+(E243:E244)+(E350:E351)+(E400:E461)+(E467:E 469)+(E520:E523)+(E525:E527)+(E534:E537)+E587+E602 +(E604:E606)+E641+E643+E701+E717+(E728:E729)+E749+ (E764:E768)+(E816:E821)+E823+(E826:E827)+E912+E915 +(E965:E967)+(E978:E980)+(E997:E1018)+(E1200:E1213 )+(E1220:E1239)+(E1262:E1273)+(E1283:E1287)+(E1325 :E1326)+(E1332:E1333)+(E1335:E1346)+(E1398:E1593))