Move formula 1 column but have the range move 3 columns

[MWDB]

Hi and thanks for the help in advance,

I can't remember how I did it in the past.

I have a sum formula in cell F21 =SUM(F16:H16). I want to drag the formula to cell G21 but then have the range to be =SUM(I16:K16). I know that offset works for this but can't figure it out.

Thank and kind regards.

Martin

 

[Fluff]

How many cells do you want this in?

 

[Fluff]

How about

=SUM(INDEX($F$16:$X$16,COLUMNS($F21:F21)*3+{-2,-1,0}))

 

[MWDB]

How many cells do you want this in?

Hi there, the total range of the data i want to sum is 77 columns.

 

[MWDB]

How about

=SUM(INDEX($F$16:$X$16,COLUMNS($F21:F21)*3+{-2,-1,0}))

So the tootal number of columns with data in it is 77.

 

[Fluff]

Did that formula work?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:Drag formula 1 cell to the right but have the range of the sum move 3
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.