SUM function settings

[George]

Hello
The SUM function allows up to 30 numbers to be added
=SUM(number1;number2;;;numbern;;;number30). Is there a way to modify
the settings of this function to accommodate more numbers?

 

[Mike H]

George,

=Sum(a1,a3,etc to 30)+Sum(b1,b2 etc up to another 30)

Mike

 

[Ken Wright]

Contiguous ranges should only use up one of those arguments, eg:

=SUM(A1:A1000,B2,C3,D455,E6,F6,G2:G345) etc

You can always use more than one SUM function and them if you really need
to, but if that's the case then generally I would suggest you either be
looking at another function, eg SUMIF/SUMPRODUCT etc, or perhaps
restructuring your data.

Regards
Ken........................

 

[David Biddulph]

It's up to 30 arguments, not 30 numbers. The arguments can be ranges, each
of which contain many numbers.

Also, remember that you can use
=number1+number2+...+numbern+...+number30+number31+number32+... without the
SUM function.

 

[RagDyeR]

You can exceed the 30 argument limit by simply using a double parenthesis.

=Sum((arg1,arg2,arg3, ... arg50,arg51, ...etc.))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hello
The SUM function allows up to 30 numbers to be added
=SUM(number1;number2;;;numbern;;;number30). Is there a way to modify
the settings of this function to accommodate more numbers?