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"

    Was this answer helpful?

    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

    Was this answer helpful?

    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.

    Was this answer helpful?

    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.

    Was this answer helpful?

    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

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments