Dynamic Function Reference Question
 

Does anyone know of a way to do this:

Cell 1: STDEV
Cell 2: =SUM(SomeRange)

where instead of retyping "STDEV" in Cell2 to change the function name, u
reference to Cell1 as the function name? so basically a dynamic way of
changing function name as a form of reference from another cell...

seems simple.. but never heard its been done.. hope for solution without vba
help.

Hi

It simply doesn't work this way.
The nearest to what you want, and functional, is something like this
=CHOOSE(MATCH(Cell1;{"Count";"CountA";"Sum";"Avera ge"};0);COUNT(YourRange);C
OUNTA(YourRange);SUM(YourRange);AVERAGE(YourRange) )

When combining the formula above with dynamic range(s) as YourRange (and
maybe determining the range YourRange through INDIRECT), you can make this
flexible enough for some easier tasks.



Arvi Laanemets


"excel newbie" <excel wrote in message
...
Does anyone know of a way to do this:

Cell 1: STDEV
Cell 2: =SUM(SomeRange)

where instead of retyping "STDEV" in Cell2 to change the function name, u
reference to Cell1 as the function name? so basically a dynamic way of
changing function name as a form of reference from another cell...

seems simple.. but never heard its been done.. hope for solution without
vba
help.