+ Reply to Thread
Results 1 to 7 of 7

Need help in Index, Match usage to match multiple criteria in sum function

  1. #1
    Registered User
    Join Date
    07-31-2016
    Location
    Tokyo
    MS-Off Ver
    2010
    Posts
    18

    Unhappy Need help in Index, Match usage to match multiple criteria in sum function

    Dear all,
    I want to collect my data like the attachment and now using Index, Match to match multiple criteria but not sure how to sum the numbers and Concatenate strings
    and would be thankfull if anybody could help.

    Sorry cannot attach file.??

    Best regards,
    SummerGirl
    Attached Files Attached Files
    Last edited by Summer0830; 03-26-2017 at 02:25 AM. Reason: Changed name:)

  2. #2
    Registered User
    Join Date
    07-31-2016
    Location
    Tokyo
    MS-Off Ver
    2010
    Posts
    18

    Re: Need help in Index, Match usage to match multiple criteria in sum function

    Sorry can anybody help how to attach my excel file?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help in Index, Match usage to match multiple criteria in sum function

    Looks like you got the file attached?

    I will take a look for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help in Index, Match usage to match multiple criteria in sum function

    So in F28, you want to show a match for Summary and the Label - for Period 08?

    Is the Key unique? could you use that instead?
    Will there be more than 1 match?

  5. #5
    Registered User
    Join Date
    07-31-2016
    Location
    Tokyo
    MS-Off Ver
    2010
    Posts
    18

    Re: Need help in Index, Match usage to match multiple criteria in sum function

    FDibbins
    Thanks for looking in to my problem.

    Yes. The key is unique for each row.
    I used Parent Name as this is the only link to connect Parent and child.

    If its a single row my current formula works for Period , Estimate, Actuals for each phase (F28, G28, H28)
    But when it has multiple rows, I am stuck up. (F29,G29, H29)
    Expected results
    F29: P08, P09 (All period for investigate)
    G29:H7+H8 (total estimate efforts for investigate)
    H29:I7+I8 (total actual efforts for Investigate

    Your help is very much appreciated.
    Last edited by Summer0830; 03-26-2017 at 02:29 AM. Reason: Add expected result

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help in Index, Match usage to match multiple criteria in sum function

    But if Key is unique, and you have that, why do you need anything else?

  7. #7
    Registered User
    Join Date
    07-31-2016
    Location
    Tokyo
    MS-Off Ver
    2010
    Posts
    18
    Quote Originally Posted by FDibbins View Post
    But if Key is unique, and you have that, why do you need anything else?
    Sorry could not understand.
    Each row has its unique key, but when I want to
    create report as shown in the attachment how can I do with
    Key?
    Please explain me.
    If possible can you reflect your idea into the attachment and
    Help me?
    Sorry for the inconvenience

+ 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. Index/Match to Match entries on multiple criteria
    By manning457 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 02:32 PM
  2. [SOLVED] Index-Match function with multiple criteria
    By MikeSta4ord in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-05-2015, 12:51 PM
  3. How do you drag down an index match function with multiple criteria?
    By larryg003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2014, 01:26 PM
  4. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  5. Using MATCH and INDEX function with multiple criteria
    By Babylon in forum Excel Programming / VBA / Macros
    Replies: 52
    Last Post: 02-06-2014, 11:28 AM
  6. Index and match function multiple criteria
    By mfortier3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2013, 05:27 AM
  7. SOS:Return multiple values against multi criteria match and index function
    By nitesh_inin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2012, 05:45 PM

Tags for this Thread

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