| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISFORMULA(Cell Referance) | Excel Worksheet Functions | |||
| how do i referance an adjacent cell from a search? | Excel Discussion (Misc queries) | |||
| Formula that referance a Cell | Excel Programming | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Cell referance for formula | Excel Worksheet Functions | |||
Hybrid Mode
