OK. Here is a bit more complicated spin on the same problem. Assume I have
numbers in A1:A5. I would like in column B to put a formula:

B1=SUMPRODUCT($A$1:A5,A1:$A$5)
B2=SUMPRODUCT($A$1:A4,A2:$A$5)
..
..
B5=SUMPRODUCT($A$1:A1,A5:$A$5)

The challenge is to copy down the formula, but the first range is moving in
the opposite direction. Any ideas how to solve this? Many thanks.

Branko


"T. Valko" wrote in message
...
You're welcome!

--
Biff
Microsoft Excel MVP


"Branko Pecar" wrote in message
...
Very, very cool. A real life saver. Thanks guys.

Branko

"Rick Rothstein" wrote in message
...
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