Automatically update formula

[Nicole]

It's kind of difficult to explain - I want to enter new rows and have it
automatically update the formula without me entering anything. Is there
anyway to do that?
Here's theh scenario - I have a formula to calculate sales as =SUM(a range)
then another formula to calculate budget with =SUM(range)*% + SUM(range)*%,
etc. I want to be able to add a row in between the range and it affect the
budget, but not the sales...the ranges are the same...this is the problem.
I hope that made sense to someone - because I'm extremely confused.

 

[Frank Kabel]

Hi
could you paste some example rows of your data and what you want to add

 

[RagDyer]

Don't know if I exactly understand what you're looking for, but if your
original sales formula is:

=SUM(A1:A25)

And you wish to keep just the first 25 rows in the formula, even if you
insert others, you could try this:

=SUM(INDIRECT("A1:A25"))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


It's kind of difficult to explain - I want to enter new rows and have it
automatically update the formula without me entering anything. Is there
anyway to do that?
Here's theh scenario - I have a formula to calculate sales as =SUM(a range)
then another formula to calculate budget with =SUM(range)*% + SUM(range)*%,
etc. I want to be able to add a row in between the range and it affect the
budget, but not the sales...the ranges are the same...this is the problem.
I hope that made sense to someone - because I'm extremely confused.

 

[Nicole]

Here is a short example:

CONTR
GROUP RATE JAN FEB MAR

LL 4.0% 73,190 68,349 76,342
LL 4.0% 79,358 80,540 91,178
LL 2.0% 90,158 88,540 109,889
LL 4.0% 94,327 97,745 100,942

TOTAL SALES 314,683 215,818 324,718


TV BUDGET 29,587 29,741 37,579


We want to be able to add more companies (LL) anywhere in that group and the
sales not change. There is a formula for total sales which is just a sum and
then another formuula for TV budget...which is sum of sales with same
contribution rate plus sales of other contribution rates...we want the tv
budget to automatically adjust according to new stores added, but keep sales
the same because those are flat - nonchanging entities. I hope this helps.
THanks for your input.

 

[Nicole]

I read up on this suggestion and it sounds like it might help. However when I
put it into the long equation (the ex. I gave before was short, simple) it
gives me a #REF!. the equation
There are different sets within the formula - like SUM(E10:E23,E25:E28). Can
I still do this...

 

[RagDyer]

The examples that you posted to Frank made no sense to me.
None of the total sales match what you display.

Could you be more specific in your examples and explanations?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I read up on this suggestion and it sounds like it might help. However when
I
put it into the long equation (the ex. I gave before was short, simple) it
gives me a #REF!. the equation
There are different sets within the formula - like SUM(E10:E23,E25:E28). Can
I still do this...