Thread: Cell prompts formula??

Say I have a fixed range of random numbers... ($A$1:$A$10)

In the following cells I have the text:
C1 "SUM"
C2 "MAX"
C3 "MIN"
C4 "AVERAGE"
C5 "COUNT"

Is there a way to look at those cells and have them prompt the corresponding formula? I know I am missing something but say I am in Cell D1 - D5 here is essentially what it looks like (but is not working at the moment).

=C1&($A$1:$A$10) - so that the formula knows to automatically SUM the range
=C2&($A$1:$A$10) - so that the formula knows to automatically find the MAX of the range
=C3&($A$1:$A$10) - so that the formula knows to automatically find the MIN of the range

Hi,

in D3 put this ...

=IF(C3="SUM";SUM($A$3:$A$11);IF(C3="MAX";MAX($A$3:$A$11);IF(C3="MIN";MIN($A$3:$A$11);IF(C3="AVERAGE" ;AVERAGE($A$3:$A$11);IF(C3="COUNT";COUNT($A$3:$A$11);"NULL")))))

... and than drag down to the other cells. It is not the best solution, but it is working. There is Excel function INDIRECT, but I think that their purpuse is to read "cell's name" (F3), not formulas as "SUM".

I think that you'll need to replace ";" with "," in formula.


Cheers, Marko

Yeah, I ended up doing what you suggested ... great minds think a like!

I hope someone knows a short cut though.. that would be great