View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clif McIrvin Clif McIrvin is offline
external usenet poster
 
Posts: 4
Default indirect with address list

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