Formula in opposite direction

[Branko Pecar]

Hi all,

I have numbers in columns A1:A5 and in B1:B5. I would like to add them in
column C, so that they follow the formula: C1=A1+B5, C2=A2+B4,..., C5=A5+B1.
How do I do it with one formula that I can copy/paste down column C, rather
than typing it in every cell?

Many thanks.

Branko

 

[T. Valko]

see your other post