Offset Problem

[Dawn]

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

 

[T. Valko]

Try this:

Entered in B1 and copied down to B10:

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

 

[Dawn]

Thanks Biff.

Try this:

Entered in B1 and copied down to B10:

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

 

[Stefi]

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:

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks Biff.