Hi all,

I would like to create a "drop down menu" of functions (sum, average, count, max, min, etc) that could be used to calculate a column in my spreadsheet. See below picture -- how do I do this? So for example, when you click "average" on the drop down menu, it calculates the average of all the numbers in the AP column. When you click "sum", it calculates the sum of all the values in the column AP.

dropdown menu.png

Let me know if this is unclear.

Thank you!