+ Reply to Thread
Results 1 to 2 of 2

Multiple selections using data validation (sumifs)

  1. #1
    Forum Contributor
    Join Date
    02-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    191

    Multiple selections using data validation (sumifs)

    Not sure what the best method is but I want to be able to select multiple criteria in column a. for example, United States and United Kingdom and then my sumifs includes BOTH of those countries. I could put another country field but the selections might be variable. Like I might want to see top 5 markets or EU and i don't want to just create the aggregate data for them on their own. Also if possible with the other criteria (e.g. class and/or account type).

    Not sure if maybe adding a macro with a "+/-" button would work and if I add a + it will add those 3 additional fields and update the SUMIF to encompass that? What are your thoughts?

    Revenue Metrics Dashboard.xlsx

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Multiple selections using data validation (sumifs)

    I think your best approach would be to create Pivot Tables on a dashboard sheet that has Slicers (your column A criteria filters). Your data is exactly what the Pivot Tables\Slicers\Dashboards features were designed for.

    If you do a simple web search for something like Excel Pivot Table Slicers Dashboards tutorial, you will find several very good step-by-step guides and videos. Here's one video guide. There are many others.
    Excel Pivot Table DASHBOARD
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple selections from data validation list
    By astasinim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 11:20 AM
  2. omit menu items via data validation for multiple selections and multiple menus when select
    By themattyp503 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2014, 12:16 AM
  3. [SOLVED] VBA to check if Data validation selections are not duplicated
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2014, 02:21 PM
  4. Filter Multiple Selections Data Validation
    By yisfromer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 12:23 PM
  5. Multiple selections from data validation macro
    By strud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 05:09 AM
  6. Replies: 4
    Last Post: 03-13-2013, 07:52 AM
  7. Replies: 3
    Last Post: 06-16-2011, 10:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1