+ Reply to Thread
Results 1 to 5 of 5

Why my formula does not work ? ( Sumif + Index + Match)

  1. #1
    Registered User
    Join Date
    06-21-2018
    Location
    hong kong
    MS-Off Ver
    2017
    Posts
    1

    Why my formula does not work ? ( Sumif + Index + Match)

    Anyone knows why my formula does not work ? Thank You

    Error.png

  2. #2
    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: Why my formula does not work ? ( Sumif + Index + Match)

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Why my formula does not work ? ( Sumif + Index + Match)

    It looks like you should have two commas after the $L$11 in the INDEX term, although it is difficult to read from the picture.

    Hope this helps.

    Pete

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Why my formula does not work ? ( Sumif + Index + Match)

    I see this thread has been marked as Solved. It would have been courteous to have given some feedback.

    Pete

  5. #5
    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: Why my formula does not work ? ( Sumif + Index + Match)

    wow Pete, definitely better eyes than me

+ 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. Having a ton of trouble with this index/match/sumif formula
    By relmasri in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-26-2016, 09:50 AM
  2. Sumif with Index Match Formula
    By khadyal in forum Office 365
    Replies: 1
    Last Post: 09-18-2015, 02:43 AM
  3. Sumif involving maybe an OR or index/match formula...
    By bridge4444 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2015, 06:09 AM
  4. Vertical Sumif or Match index Formula help
    By Timmy Seals in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2014, 10:19 AM
  5. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  6. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  7. Excel 2007 : Index and Match Formula does not work
    By Porterrob in forum Excel General
    Replies: 1
    Last Post: 11-01-2010, 11:09 AM

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