Copy addition formula of non-consecutive horizontal cells


Joined
Aug 18, 2020
Messages
3
Reaction score
0
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
 
Ad

Advertisements

Joined
Sep 21, 2021
Messages
1
Reaction score
0
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top