ExcelBanter - Offset Problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Offset Problem (https://www.excelbanter.com/excel-discussion-misc-queries/190798-offset-problem.html)

Dawn

Offset Problem

There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;€¦B10=A19+A20;
How to realize it ?
Thanks
Dawn

T. Valko

Offset Problem

Try this:

Entered in B1 and copied down to B10:

=SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*2,,2))

--
Biff
Microsoft Excel MVP

"Dawn" wrote in message
...
There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;.B10=A19+A20;
How to realize it ?
Thanks
Dawn

Dawn

Offset Problem

Thanks Biff.

"T. Valko" wrote:

Try this:

Entered in B1 and copied down to B10:

=SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*2,,2))

--
Biff
Microsoft Excel MVP

"Dawn" wrote in message
...
There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;.B10=A19+A20;
How to realize it ?
Thanks
Dawn

Stefi

Offset Problem

Enter this formula in B1 and pull it down to B10:
=INDEX(A:A,2*ROW()-1)+INDEX(A:A,2*ROW())

Regards,
Stefi

€žDawn€ ezt Ã*rta:

There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;€¦B10=A19+A20;
How to realize it ?
Thanks
Dawn

T. Valko

Offset Problem

You're welcome!

--
Biff
Microsoft Excel MVP

"Dawn" wrote in message
...
Thanks Biff.

"T. Valko" wrote:

Try this:

Entered in B1 and copied down to B10:

=SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*2,,2))

--
Biff
Microsoft Excel MVP

"Dawn" wrote in message
...
There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;.B10=A19+A20;
How to realize it ?
Thanks
Dawn

All times are GMT +1. The time now is 07:31 AM.