AutoSum Limitation?

Does anyone know what the limitation is on how many cells
you can use in a Sum function?

I ask because I'm trying to total about 60 cells into 1
and receive the following error message:

"The formula you typed has an error:

For information about fixing common formula problems,
click Help.

To get assistance in entering a function, click OK, then
click Function on the Insert menu.

If you are not trying to enter a forumla, avoid using an
equal (=) sign or minus (-) sign, or precede it with a
single quotation mark(')."

I've never had any problems using the autosum feature to
add up cells spreadout through a spreadsheet.

"Kelly" wrote...
Does anyone know what the limitation is on how many cells
you can use in a Sum function?

I ask because I'm trying to total about 60 cells into 1
and receive the following error message:

"The formula you typed has an error:
...

Looks like you're trying to sum more than 30 individual cells. All functions
called from worksheet formulas, including SUM, are limited to 30 or fewer
arguments. That means a formula like

=SUM(B4,D4,F4,H4,J4,L4,B6,D6,F6,H6,J6,L6,
B8,D8,F8,H8,J8,L8,B10,D10,F10,H10,J10,L10,
B12,D12,F12,H12,J12,L12,B14,D14,F14,H14,J14,L14,
B16,D16,F16,H16,J16,L16,B18,D18,F18,H18,J18,L18)

is syntactically invalid. The error message you receive would highlight B14 in
the formula above, which is the 31st argument. One work-around is to make the
cells a single multiple-area range, e.g., replace the invalid formula above with

=SUM((B4,D4,F4,H4,J4,L4,B6,D6,F6,H6,J6,L6,
B8,D8,F8,H8,J8,L8,B10,D10,F10,H10,J10,L10,
B12,D12,F12,H12,J12,L12,B14,D14,F14,H14,J14,L14,
B16,D16,F16,H16,J16,L16,B18,D18,F18,H18,J18,L18))

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.