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