| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to do 'Nested' cell references
I have a cell (C3) in a 'Totals' worksheet summing the contents of cells in
other worksheets (named APPL, ACRF, OMAC, OPNG & ACRD) by using the formula: =sum(APPL!C72+ACRF!C72....) Simple, so far. I want to be able to edit the row number - 72 - globally by refencing it in another cell (E23) on the Totals worksheet such as: =sum(APPL!C[I23]+ACRF!C[I23]...) You can see what I'm after... I want to enter '73' in cell E23 on the Totals worksheet and have the formula sum the contents of the next row down from each of the worksheets. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying multiple cell references in 1 cell | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| drop-down menus and nested references | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Threaded Mode
