I just noticed I forgot to make the range in the first argument absolute
(which is necessary so that you can correctly copy it down)...

=A1+INDEX(B$1:B$5,6-ROW(A1))

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Try this formula in C1 and then copy it down...

=A1+INDEX(B1:B5,6-ROW(A1))

--
Rick (MVP - Excel)


"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