Formula in opposite direction

  • Thread starter Thread starter Branko Pecar
  • Start date Start date
B

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
 
Back
Top