Share via

Drop down list containing formulas

Anonymous
2012-08-27T23:04:12+00:00

I need to create a drop down list that contains Excel formulas (Average, Count, Sum, etc).

Is there an easy way to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-01-25T01:52:44+00:00

    Your data should be in a table.

    Click the table 

    Design > check "Totals Row"

    20+ people found this answer helpful.
    0 comments
  2. Kevin Jones 7,265 Reputation points Volunteer Moderator
    2012-08-27T23:15:16+00:00

    Can you be more specific? Do you want the formula results displayed? Or do you want the drop down list to change the formula in that cell?

    Kevin

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2012-08-30T21:57:19+00:00

    In the drop down are the following functions:

    None

    Average

    Count

    Count Numbers

    Max

    Min

    Sum

    StdDev

    Var

    Other Functions...

    When a function is chosen the calculation is shown in that same cell that contains the drop down.

    6 people found this answer helpful.
    0 comments
  4. Anonymous
    2012-08-28T17:33:04+00:00

    This is not what I am looking for.  The drop down automatically tabulates the formulas - I don't have to type in a formula anywhere.

    Also the last choice in the drop down is "More Functions".  When you click on that it opens the Excel Insert Function box.

    So, I guess I want the Data Validation to have a drop down list of function - still don't know how to do this.

    5 people found this answer helpful.
    0 comments
  5. Anonymous
    2012-08-28T01:00:07+00:00

    select the cell

    choose Data => Validationi

    in the "Allow:" dropdown choose list

    in the resulting textbox  ("Source:")   type

    Average,Count,Sum,etc

    (just type your list of choices - no qoutes or double quotes needed.  If your list separator is not a comma, use your list separator as the delimiter.

    then click OK. 

    say that A1 is the cell with the data validation dropdown.

    in another cell

    =if(A1="","",if(A1="Average",Average(B1:B10),if(A1="Count",count(B1:b10,if(A1="Sum",Sum(B1:B10),"etc))))

    --

    Regards,

    Tom Ogilvy

    2 people found this answer helpful.
    0 comments