Using EVALUATE to create a formula from text

I am trying to put a formula in cell B1 that changes as a user selects a function (Sum, Average, Median etc) from a drop down in cell A1. I can accomplish this with

Formula:

Please Login or Register  to view this content.

, where (C10:C30) references a column of numerical data, however I wondered if there was a way to write a formula that would change the function to match the drop down such as

Formula:

Please Login or Register  to view this content.

which produces a #VALUE! error? I started by wrapping this with Concatenate i.e.

Please Login or Register  to view this content.

which populated cell B1 with the text "=SUM(C10:C30)". I had found a thread suggested using INDIRECT wrapped around CONCATENATE to solve another problem so I tried

Formula:

Please Login or Register  to view this content.

however it produced a #REF! error. I have also read about an add-in, Morefunc, that allows evaluation of text formulas from http://xcell05.free.fr/english/, however I was not able to connect to this link, and was also not sure if this would create portability issues. Is there a way to do what I am suggesting in my first sentence using portable Excel 2010 functions?

ExampleStatsDropDown.xlsx

Can you post a copy/SAMPLE of a model that you have of this scenario -

This will produce quicker results for you and makes it less work on the forum when trying to offer up solutions.

If it is not sensitive data and the file is not giant feel free to share the current file, otherwise just recreate it in a sample workbook and then clarify where the variables are so we can test your current process and look for solutions that don't require plugins/downloads

Go advanced to post files ALT+X

there is already and excel 4 macro that you can call
from formula tab
insert name /new
call it say calculate
in refers to put
=EVALUATE(Sheet1!$A$1&"(c1:c10)") where a1 has your drop down
now use as =calculate
save as xlsm tho