Need to do the sum of a range+individual cells: (B2:B9)+B15=(B19:B

T

T. Otten

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:E469)+(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))
 
T

T. Valko

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)
 
T

T. Otten

Perfect, that did it, thank you!



T. Valko said:
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 said:
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:E469)+(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))
Click to expand...
Click to expand...
 
T

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


T. Otten said:
Perfect, that did it, thank you!



T. Valko said:
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 said:
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:E469)+(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))
Click to expand...
Click to expand...
Click to expand...
 
Top