Formulas Adjusting

S

StephanieH

I have the following formula on a Rollup page
SUM(ARP:BEL!B4)

I need to insert 2 columns on pages ARP through BEL without the formula on
my Rollup page adjusting to SUM(ARP:BEL!D4). I've also tried
SUM(ARP:BEL!$B4) but it doesn't matter. When I insert the columns, it
changes to SUM(ARP:BEL!$D4).

Any suggestions?
 
F

Frank Stone

hi,
adding columns and rows to excel causes formulas to adjust
to the newly added columns and/rows. it is built into
excel. if you really need the 2 columns, your best bet is
just to change the formula on your rollup page to
sum(arp:bel!B4
Regards
Frank
 
S

StephanieH

Thanks Frank.

Frank Stone said:
hi,
adding columns and rows to excel causes formulas to adjust
to the newly added columns and/rows. it is built into
excel. if you really need the 2 columns, your best bet is
just to change the formula on your rollup page to
sum(arp:bel!B4
Regards
Frank
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to center adjust text above and image in a two column document. 1
The sum of the same function that is used for a range of cells 2
Using MATCH here 1
Space at end of multi page list to accommodate new entries 1
Need Help with a VBA subroutine 0
Simple calc not working as expected - what am I missing? 7
+ / - Percentage Variation 3
Help With Nested SumIf / Or 4

Top