Prev: Can't open already opend files since changeover.
Next: PLease HELP - Track Changes not working right
From: Dan Maddock Dan on 23 Apr 2010 12:57 I have a formula: =SUM('Daily from Mar 2010'!AZ4:BF4) In the cell to the right of the above cell I want the formula to be =SUM('Daily from Mar 2010'!BG4:BM4) Whenever I try to use autofill it populates the cell with the following formula instead: =SUM('Daily from Mar 2010'!BA4:BG4) I really need it to jump 7 columns instead of just the one. Can anyone help? |