How to extend formulas from (say) 3 rows to many rows?

[iVenky]

Hello everyone,

I have a problem. I will explain with an example

Let's take

A1: 1
A2: 2
A3: 3
A4: 4
A5: 5
A6: 6
A7: 7
A8: 8
A9: 9
A10: 10
A11: 11
A12: 12

are the values present in the cells.

What I have to do is

=SUM(A1;A2) in B2
=SUM(A1;A3) in B3
=SUM(A1;A4) in B4

I am summing the first row with second row and then third row and then fourth row.

Now I have to extend this to other rows as well. ( after this summing A5 with A6 and then A7 and then A8)

Is there a way to do this?


Thanks,
iVenky

[windy58]

Not sure if I understand correctly but if you want to add single cell to A1 each time place this in B2 and copy down.
=$A$1+A2

Windy

[iVenky]

Thanks a lot.

[azumi]

=SUM($A$1:A2)

in Column B2 and copied down

[azumi]

=SUM($A$1:A2)

in Column B2 and copied down