Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I tried searching, but didn't find my solution so:
I have a series of formulas that operate on a list of cells, but the list is variable. I thought to replace all references to the cell list with indirect, but it appears to fail on an address list. For simplicity, I'll use only the average function as example rather than multiple formulas: Cell I45 contains =average(I30,I37,I44) There is an empty sell at H46, so I tried: H46: I27,I34,I41 I45: =average(indirect(H46)) which fails. Is there a way to accomplish this? The reason is (for instance) when the list is I27,I34 instead of I27,I34,I41 I don't wish to change several formulas. Thanks in advance! --Clif McIrvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
using INDIRECT(ADDRESS(...)) | Excel Discussion (Misc queries) | |||
Indirect(Address(... | Excel Discussion (Misc queries) | |||
INDIRECT(ADDRESS... Across worksheets | Excel Worksheet Functions | |||
Indirect and Address in Reference to other sheets | Excel Worksheet Functions |