SUM function settings
 

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?

SUM function settings
 

George,

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

Mike

"George" wrote:

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?

SUM function settings
 

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

=SUM(A1:A1000,B2,C3,D4:D55,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........................


"George" wrote in message
...
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?

SUM function settings
 

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.
--
David Biddulph

"George" wrote in message
...
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?

SUM function settings
 

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!
================================================== ===

"George" wrote in message
...
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?