Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formula in opposite direction

0 views
Skip to first unread message

Branko Pecar

unread,
Nov 22, 2009, 9:04:16 PM11/22/09
to
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

unread,
Nov 22, 2009, 10:20:38 PM11/22/09
to
see your other post

--
Biff
Microsoft Excel MVP


"Branko Pecar" <bpe...@sbcglobal.net> wrote in message
news:%23bigDF%23aKH...@TK2MSFTNGP06.phx.gbl...

0 new messages