cell referance

hi, in sheet 1 i have got



A B C
1 2 3

IN SHEET 2 I HAVE GOT

A B C
1 2 3
IN SHEET 3 THROUGH FORMULA I WANT


A B C
2
4
6
IN VERTICLE LEVEL

THE FORMULA IN SHEET 3 A1 IS =SHEET1!A1+SHEET2!A1
I WANT A2 = SHEET1!B1+SHEET1!B1
AND SO ON

PLEASE

darsg,

In sheet3, cell A1, enter the formula

=OFFSET(Sheet1!$A$1,0,ROW()-ROW($A$1))+OFFSET(Sheet2!$A$1,0,ROW()-ROW($A$1))

and copy down as far as you require.

HTH,
Bernie
MS Excel MVP


"darsg" <darsg@discussions.microsoft.com> wrote in message
news:EA3DD67E-223B-4AD1-AC23-D6D1274627AF@microsoft.com...
> hi, in sheet 1 i have got
>
>
>
> A B C
> 1 2 3
>
> IN SHEET 2 I HAVE GOT
>
> A B C
> 1 2 3
> IN SHEET 3 THROUGH FORMULA I WANT
>
>
> A B C
> 2
> 4
> 6
> IN VERTICLE LEVEL
>
> THE FORMULA IN SHEET 3 A1 IS =SHEET1!A1+SHEET2!A1
> I WANT A2 = SHEET1!B1+SHEET1!B1
> AND SO ON
>
> PLEASE
>
>
>
>