Copy addition formula of non-consecutive horizontal cells

[GHBmusic]

Cannot solve this simple non-consecutive horizontal cell addition and copy-paste the formula.

In cell B62 I have this addition: =D15+F15+N15+P15+T15
In cell C62 I want this addition: =D16+F16+N16+P16+T15

Of course dragging the formula across from column B to O does not work.

The row range goes from 15 to 41 (27 rows) and is to be displayed in columns B62:N62 and B65:O65.

I can easily do this manually 27 times but would love to know if there is a quicker way to achieve this please.

Thanks in advance, regards,

George

 

[Toptech KIT]

Cannot solve this simple non-consecutive horizontal cell addition and copy-paste the formula.

In cell B62 I have this addition: =D15+F15+N15+P15+T15
In cell C62 I want this addition: =D16+F16+N16+P16+T15

Of course dragging the formula across from column B to O does not work.

The row range goes from 15 to 41 (27 rows) and is to be displayed in columns B62:N62 and B65:O65.

I can easily do this manually 27 times but would love to know if there is a quicker way to achieve this please.

Thanks in advance, regards,

George

Based on your example, the Columns are fixed but the rows are changing. D15 to D16. The column is the same "D" but the row has changed from 15 to 16. This means we fix the column i.e. by adding a dollar sign. This is what a mean, = $D15+ $F15+ $N15+ $P15 + $T15. Use this to copy across.

 

[GHBmusic]

Thank you Toptech for your solution.
It works perfectly. Problem solved.
George