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
|