On Mar 11, 3:01*pm, Clif McIrvin wrote:
On Mar 11, 2:42*pm, Gary''s Student

wrote:
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

But, the plot thickens. *I debated how much detail to include, I see I
left out a critical bit:

The workbook contains a pile of sheets of identical format, and this
situation exists on each sheet (in multiple workbooks.) this "named
range" must be able to be different on each sheet.

In the meanwhile, I have devised a work-around utilizing space "off to
the side" (that is, outside of the print view.)

In column M I have created a stack of formulas, for instance:

M42: * =I30
M43: * =I37
M44: * =I44
M45: * M42:M44

aarggh! Fat-finger error! :(

and now

I45: =average(indirect(M45))

works as I expect it to. When the data on a new sheet has different
requirements, I can simply change M45 to, say, M42:M43 and the
formulas behave as I expect.

(I am dealing with test data, and each sheet represents a different
sample. The more I learn about what Excel (and Access) can do
the more I believe I would have set things up differently, but - alas!
-
this is an inherited system, so for now, at least, I'm stuck with the
layout I have.)

--Clif