summing more than 30 numbers

S

stevientx

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?
 
M

mphell0

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,number32...)]
 
R

Ron Rosenfeld

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?
Click to expand...

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

=SUM(A1:A1000)

How are you entering your numbers?


--ron
 
C

CLR

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
 
S

stevientx

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

Niek Otten

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.
 
Top