Limitations of the sum function?

[Jammer]

I'm trying to use the sum function to add numbers.
I have to add numbers from several places on the spreadsheet.
And because of the way they are situated, I have to choose each of the
numbers individually.
So, I have something like sum(a1,c2,a5,b5...) etc.

Now the problem is that the sum function doesn't allow me to have too
many numbers added up!!
Why is this? I think the maximum nubers you can have added are about
25 or something.

How can I get around this? There isn't an alternative function as far
as I know.

Any help would be appreciated.

Thanks.


Jam

 

[JasonMorin]

You're limited to 30 arguments as with most worksheet
functions. Your options are to define the ranges and use
something like:

=SUM(rng1,rng2,rng3)

or enclose the 1st 30 arguments within another set of
parentheses:

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A27,A29,A3
3,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59,A61),
A63,A65)

Note the closing parenthesis after A61.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
the maximum should be 30 parameters for the SUM function. One
workaround:
you can define names for several cells (goto 'Insert - Name - Define'):
- select around 20 cells
- goto this dialog and choose a name
- repeat this
- use the names in your sum formulas

Note: You may consider changing your spreadsheet layout as this is
quite unsual to have such fragmented cells for a sum