Formulas Adjusting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top