Cute... I like it!

--
Rick (MVP - Excel)


"T. Valko" wrote in message
...
Another one...

=A1+INDEX(B$1:B$5,ROWS(B1:B$5))

Copied down

--
Biff
Microsoft Excel MVP


"Branko Pecar" wrote in message
...
Assume I have numbers in cells A1:A5 and B1:B5. I would like to add them
in column C, but following this formula: C1=A1+B5, C2=A2+B2,...,C5=A5+C1.
How do I do it so that I can just use copy paste of this formula without
manually re-entering it in every cell? Thanks.

Branko