Here is a neater trick than INDIRECT()!

1. Select a pile of cells (click the first one and CNTRL-click the rest)
2. Insert Name Define clif
3. Then use:
=AVERAGE(clif)
You can use clif across many formulas. You only need to change the Defined
Name from the menu rather than change all the cells that use it.
--
Gary''s Student - gsnu2007f


"Clif McIrvin" wrote:

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