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