I think the OP had the parenthesis. The problem is that Excel limits
functions to 30 arguments within the parentheses.

However, if it's a sum you need, you don't need to use SUM(). You can use

=R8+R9+R13+R14+R17+R18+R26+R30+R31+R32+R33+R35+R40 +R41+R45+R49+R50+R51+R52+R58+R60+R61+R67+R68+R69+R 70+R71+R75+R83+R87+R2+R93+R97+R98+R108+R111+R116+R 117+R119+R124+R132+R133+Q143+R145+Q155+Q156+Q157+Q 159+Q162+Q166+Q172+Q175

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
If we knew more we might be able to simplify the formula. However, if you
are doing exactly what you have written then what you need to do is type
=SUM( not =SUM and then start clicking on each of the cells you want
to
include while holding down the Ctrl key.

--
Cheers,
Shane Devenshire


"texansgal" wrote:

Here is my formula:

=SUM(R8,R9,R13,R14,R17,R18,R26,R30,R31,R32,R33,R35 ,R40,R41,R45,R49,R50,R51,R52,R58,R60,R61,R67,R68,R 69,R70,R71,R75,R83,R87,R2,R93,R97,R98,R108,R111,R1 16,R117,R119,R124,R132,R133,Q143,R145,Q155,Q156,Q1 57,Q159,Q162,Q166,Q172,Q175)

I clicked in the cell where I want the formula to be. I put it "=SUM" and
then clicked on each cell that I wanted to using while holding down
"ctrl"...

Please tell me what I am doing wrong. I even tried without the "SUM" and
just the "=".

Thank you!

"OssieMac" wrote:

Not enough information to more than guess at what you might be doing
wrong.
How are you going into SUM? Are you clicking on the sum icon? If not,
try
using it.

Your reply suggests that you are summing non adjacent cells. Is this
correct? If so, after selecting the first cell or adjacent cells in a
range
to sum, are you holding the Ctrl key while you select the remaining
cells?

If the above does not help then when you get your error, highlight the
formula in the formula bar and copy and paste it into a reply here.
Also what
is in the cells to be summed?

Regards,

OssieMac



"texansgal" wrote:

I am trying ot put in a formula. I have a two columns with Revenue
listed.
One is the Estimate, one is the actual. If there is not an amount in
the
Actual amount column, I added the cell that was in the Estimate cell.

I color coded the cell because I am breakingit out by Sales Person. I
have 3
Sales People. I went in and did the SUM and went into each cell that
is
colored coded to each person. I am getting an error.

Please help.

Thanks,
Vanessa