# 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.

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.

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.