Setting Autofill to move more than 1 cell?

[davegrun]

Hello everyone, I am racking my brain trying to figure this out. I need to pull data from a tab inside of a worksheet, but instead of referencing consecutive cells in Autofill, I am trying to have it reference every other 13th cell. Since I have not figured this out yet, I have to go through one by one and manually type in each cell reference by adding 13 to the one before. It needs to go inside an if/then formula as well.

If anyone can help me out with this, I would be extremely grateful

[XOR LX]

Hi,

Can you give a few examples of what your first formula is, what your second should be, what your third should be, etc.?

Regards

[newdoverman]

Here are several examples of summing every Nth number as created by C Pearson.

[davegrun]

THis is the main formula:

=IF($J6=TRUE,Subs!N9,0)

This formula pulls #'s from a balance sheet tab when I check a box. I am trying to fill in the rest of the table by getting the formula to go 13 rows from N9, then another 13 (N9 to N22) until the table is filled in, rather than just going N9 to N10. Right now I'm having to manually go line by line to add 13 to each cell reference and there is too much volume to do it this way.

[XOR LX]

Try:

=IF($J6=TRUE,INDEX(Subs!N:N,9+13*(ROWS($1:1)-1)),0)

and copy down as required.

(You don't say whether the J6 is to be incremented equally in gaps of nine, nor if it is to be fixed, so I left it as in your example.)

Regards

[davegrun]

Try:

=IF($J6=TRUE,INDEX(Subs!N:N,9+13*(ROWS($1:1)-1)),0)

and copy down as required.

(You don't say whether the J6 is to be incremented equally in gaps of nine, nor if it is to be fixed, so I left it as in your example.)

Regards

Thanks! I found a similar formula on here through searching and this solved it! You guys rock