How can I autofill not using adjacent cells

D

Dan Maddock

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?
 

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

Running Sum of cell in many spreadsheets 1
Copy addition formula of non-consecutive horizontal cells 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
How can count the number of cells that fulfill certain criteria in other cells 2
How can I edit the default column autofill formula? 0
Subquery with subraction - challenging 4
how can I copy/paste a formula that skips 27 rows? 0
Import Images into cells from a file without using VBA or Macro. Can it be done ? 1

Top