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?
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...)]
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
If they are in a range, e.g. A1:A1000, you can
=SUM(A1:A1000)
How are you entering your numbers?
--ron
G
Guest
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
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.
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.
=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.