+ Reply to Thread
Results 1 to 4 of 4

using SUMIFS and adding values based on multiple criteria based on selection from the drop

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    70

    using SUMIFS and adding values based on multiple criteria based on selection from the drop

    Hi All,

    I am trying to create a sort of tool where from sheet 'Report writer' I will be selecting the options for calculation from the drop down.
    Based of these selection there is a sumif formula in 'Sheet5' Cell F5 which needs to give the results as per the selection.

    Problem arises when I do not select on of the criteria and select 'All' it does not give me any value.
    So if any one can help me in anyway to get the sum where I can do a multiple selection and where few of them may be All it should still give me the results based on the selection.

    I am not sure if I have explained this well but attached is the file for your reference.

    Thanks in advance for your help.

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: using SUMIFS and adding values based on multiple criteria based on selection from the

    Without getting into your sheet... are you asking how to make excel accept all of a field... if the word ALL is selected. For this you would likely need to set up your sheet to have cells off to the side in which your formulas are looking...

    Example... If your selection menu is in cell C6, then in D6 say
    Please Login or Register  to view this content.
    then all of your formulas should be looking to D6 for the criteria, this way the wildcard * will be the criteria for the field allowing you to get everything, or if you happen to select something else you will still get that value for the criteria within your report. . .

    Cheers
    -If you think you are done, Start over - ELeGault

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: using SUMIFS and adding values based on multiple criteria based on selection from the

    Thanks EleGault for your quick reply.

    Unfortunately I fail to understand what you are trying to tell me...
    My selection is in Report Writer and in sheet5 the details shown is only for display...

    Please let me know if I am missing something here..

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: using SUMIFS and adding values based on multiple criteria based on selection from the

    Hey muheebrahman,

    I thought you had a sheet last time I looked at this post, might just be my PC right now but it does not appear to be visible anymore. Basically you can do one of 2 things. You can make a separate location that is based on those selections you make in report writer. I was suggesting putting them right next to them but they can be in a separate sheet all together. What you would do is like I say in my formula is say If the selection is ALL then equal wildcard (*) otherwise equal original selection. Then all the formulas would look to this new reference instead of the original... OR you can add to your formulas, for the criteria, IF(SELECTION="ALL","*",SELECTION). Of course SELECTION would be your reference to the drop downs on your report writer.

+ 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. Inserting values based upon a drop down box selection
    By Altren73 in forum Excel General
    Replies: 1
    Last Post: 02-11-2015, 05:28 AM
  2. [SOLVED] Nested IF and SUMIFS - Multiple criteria based on an IF
    By wjmoore in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2014, 10:40 PM
  3. [SOLVED] Adding suffix to values based on multiple criteria.
    By mosesthetank in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2014, 02:23 AM
  4. Select multiple criteria based on check box selection and return all unique values.
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 09:14 AM
  5. Multiple selection criteria, which formula? .. and selection based on unique numbers
    By FalkirkJim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 05:22 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