How do you sum a range of more than 30 cells. I get error each time I try.
 

Here is the error message:

You've entered too many arguments for this function.

To get help with entering arguments for the function, click OK to close
this message. Then, on the formula bar, click the equal sign button
(located to the left of the equal sign in your formula).

--
Message posted via http://www.officekb.com

"Joseph Conaghan via OfficeKB.com" wrote in message
...
Here is the error message:

You've entered too many arguments for this function.

To get help with entering arguments for the function, click OK to close
this message. Then, on the formula bar, click the equal sign button
(located to the left of the equal sign in your formula).

--
Message posted via http://www.officekb.com

Instead of entering something like =SUM(A1,A2,A3), use =SUM(A1:A32)

7fredrik

Use a 2nd (or 3rd...) set of parentheses:
=SUM(A1,A5,(A7,A18,A29),A52), for example will have Excel "think" there's 4
items being added instead of 6. Use them freely, and you can get practically
any number of items!

Bob Umlas
Excel MVP

"Joseph Conaghan via OfficeKB.com" wrote in message
...
Here is the error message:

You've entered too many arguments for this function.

To get help with entering arguments for the function, click OK to close
this message. Then, on the formula bar, click the equal sign button
(located to the left of the equal sign in your formula).

--
Message posted via http://www.officekb.com

Good idea. But the cells are not sequential. They are in various
locations on the spreadsheet.

--
Message posted via http://www.officekb.com

The first step is to consolidate the ranges as Fredrik=20
suggested. If, after this step, you still have more than=20
30 ranges, consolidate further using defined names, or=20
try this technique:

You can use another set of parentheses within AVERAGE to=20
get around the limit of 30 arguments. For example:=20

=3DAVERAGE=20
((A2,A4,A6,A8,A10,A12,A14,A16,=AD
A18,A20,A22,A24,A26,A28,A30,=20
A32,A34,A36,A38,A41,A43,A45,A4=AD
7,A49,A51,A53,A55,A57,A59),A=20
61,A63,A65,A67,A69,A71,A73,A75=AD,A77,A80,A82,A84) =20


Notice how the A2 to A59 are enclosed in ( ).=20


HTH=20
Jason=20
Atlanta, GA=20

-----Original Message-----
Here is the error message:

You've entered too many arguments for this function.=20

To get help with entering arguments for the function,=20
click OK to close
this message. Then, on the formula bar, click the equal=20
sign button
(located to the left of the equal sign in your formula).

--=20
Message posted via http://www.officekb.com
.

Thanks Bob. The user will try this tomorrow and I'll post back to update
all.

--
Message posted via http://www.officekb.com