Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect?
I have the following in a workbook "ABC.xls" =ROUNDDOWN(SUM(SUMIF($B$6:$B$69,{"EE3","EE6","HE3" ,"HE6", "OE3","OE6","OHE3","OHE6"},$E$6:$E$69)),-2) I would like to place the formula in another workbook "DEF.xls" but maintaining the same references in "ABC.xls". I have used indirect on its own in the past to reference cells in other workbooks but I cannot think how to apply it in this case. Grateful for any advice. -- Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Indirect | Excel Worksheet Functions | |||
#REF using =INDIRECT... | Excel Worksheet Functions | |||
Indirect.ext #value! | Excel Discussion (Misc queries) | |||
Help with INDIRECT() | Excel Discussion (Misc queries) |