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

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

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

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

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

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