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

cell referance
 

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