summing more than 30 numbers
 

I am trying to sum over 37 numbers and am being stopped at 30. Is there
a way to sum more than 30 numbers at a time?


--
stevientx
------------------------------------------------------------------------
stevientx's Profile: http://www.excelforum.com/member.php...o&userid=32349
View this thread: http://www.excelforum.com/showthread...hreadid=521050

summing more than 30 numbers
 

Are the numbers non-contiguous?

If they are all together you can put:
=SUM(A1:A37)

If they are non-contiguous and you are using the form
=SUM(number1,number2,...,number37) it will stop you at 30 numbers.

The way around that is to either put a plus sign in between each one
[=number1+number2+number3...]

or break it up into two different SUMs
[=SUM(number1,number2,...,number30)+SUM(number31,nu mber32...)]


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=521050

summing more than 30 numbers
 

On Fri, 10 Mar 2006 08:07:54 -0600, stevientx
wrote:


I am trying to sum over 37 numbers and am being stopped at 30. Is there
a way to sum more than 30 numbers at a time?

If they are in a range, e.g. A1:A1000, you can

=SUM(A1:A1000)

How are you entering your numbers?


--ron

summing more than 30 numbers
 

If the numbers are in consecutive cells, you can group them with the colon
and only have to type the first and last cell in the series.......such as

=SUM(A1,B5,C13:C23,A25,H27:K27,....ETC ETC)

hth
Vaya con Dios,
Chuck, CABGx3



"stevientx" wrote:


I am trying to sum over 37 numbers and am being stopped at 30. Is there
a way to sum more than 30 numbers at a time?


--
stevientx
------------------------------------------------------------------------
stevientx's Profile: http://www.excelforum.com/member.php...o&userid=32349
View this thread: http://www.excelforum.com/showthread...hreadid=521050

summing more than 30 numbers
 

Non-contiguous. Did the multiple sums and it worked like a charm.
Thanks so much for your help.:)


--
stevientx
------------------------------------------------------------------------
stevientx's Profile: http://www.excelforum.com/member.php...o&userid=32349
View this thread: http://www.excelforum.com/showthread...hreadid=521050

summing more than 30 numbers
 

And if you enclose a group of cells in parens, it counts as one (for this function, not for all!)

=SUM((a1,a3,a5,a7,a9),(a11,a13,a15,a17)) has two arguments, not 9. The maximum number of arguments for any function in Excel is
30.

--
Kind regards,

Niek Otten

"mphell0" wrote in message
...

Are the numbers non-contiguous?

If they are all together you can put:
=SUM(A1:A37)

If they are non-contiguous and you are using the form
=SUM(number1,number2,...,number37) it will stop you at 30 numbers.

The way around that is to either put a plus sign in between each one
[=number1+number2+number3...]

or break it up into two different SUMs
[=SUM(number1,number2,...,number30)+SUM(number31,nu mber32...)]


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=521050