DESPERATE FOR HELP! Drag formula and skip colums

[evilchris]

hi,

i am currently working on a document where i am pulling data from another work sheet, but i need to skip columns when i drag my formula down to the next row.

for example, i want to drag formula "=SUM('2016 Project Breakout'!D12:D17)" down to the next row and have it be "=SUM('2016 Project Breakout'!F12:F17)"

is this possible, and if so, please let me know.

thanks very much,
chris

 

[JoeMo]

If you are willing to use a helper column to hold your column letters like the example below, here's one way (copy B1 down to cover all relevant column letters).

Excel Workbook
	A	B
1	D	6
2	F	12
3	H	18
4	J	24
Sheet7