As I posted in another strand of this thread:
=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
I think now the limit is 1024 characters.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"texansgal" wrote in message
...
OK... That is what it is then. I have too many arguments. How can I create
an
intermediate formula? I am sorry... I am semi-new at formulas.
"ShaneDevenshire" wrote:
Hi Texansgal,
I missed another point - if you are using Excel 2003 the maximum number
of
arguments for any function is 30. You can reduce the number in your
sample
formula if you replace references such as:
=SUM(R8,R9,R13,R14,R17,R18,R26,R30,R31,R32,R33,R35 ,R40,R41,
with
=SUM(R8:R9,R13:R14,R17:R18,R26,R30:R33
and so on. In other words R30,R31,R32,R33 counts at 4 arguments but
R30:R33
counts as 1.
If this still doesn't get you under the 30 argument limit you can create
intermediate formulas, for example two formulas with 30 arguments and a
third
formula that sums those two.
Alternatively you can use Excel 2007 it supports 256 arguments.
--
Cheers,
Shane Devenshire
"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