Hi! Can anyone help me on how to put formulas as a drop down list in a certain cell?

Occasional Visitor

I was going through excel sheet formulas for sales team target & I came across a sheet that is formulated. I really want to know how to put the formulas as options in a drop-down as shown in the picture I have attached herewith. Please help. Thanks in advance.Screenshot 2021-02-06 at 1.08.03 PM.png

1 Reply


To my knowledge that doesn't work such way. If you are working with structured table, list of aggregation from drop-down is only in Total row at the bottom of the table. On the top, or at any other place, you only could make the reference on Total.