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