+ Reply to Thread
Results 1 to 4 of 4

Pls help with a sumifs index match formula

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    88

    Pls help with a sumifs index match formula

    Please can you guide me as I'm not sure what I do wrong with this formula
    =SUMIFS(INDEX('2018 volume'!$A$1:$N$70,0,MATCH($E$1,'2018 volume'!$C$1:$N$1,0)+COLUMNS($C:$C)-1),'2018 volume'!$A$1:$A$70,$A3)
    workbook attached
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Pls help with a sumifs index match formula

    I suppose that COLUMNS($C:$C) is not right.

    Try COLUMNS($C:C)

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Pls help with a sumifs index match formula

    Please try at D2

    =SUMIFS(INDEX('2018 volume'!$A$1:$N$70,0,MATCH(D$1,'2018 volume'!$A$1:$N$1,0)),'2018 volume'!$A$1:$A$70,SUBSTITUTE($A2,", CSA",""))
    Last edited by Bo_Ry; 02-20-2019 at 04:38 AM.

  4. #4
    Registered User
    Join Date
    01-02-2014
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Pls help with a sumifs index match formula

    Hi
    the answer I'm looking for in D2 & D3 should be as follows
    Plant Terminal Product January-2018
    JBS SEAFARERS CIRCLE, TRM, CSA JBS Fuel Oil 6 803 286
    JBS SEAFARERS CIRCLE, TRM, CSA JBS Marine Gas Oil 6 502 749
    I tried the above

+ 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. [Please Help Me] Solving =SUMIFS or INDEX or MATCH Formula for Data Across (2) Tabs
    By ChrisNeedsHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2017, 05:40 PM
  2. Replies: 2
    Last Post: 11-10-2017, 03:12 PM
  3. Formula Help Needed - Sumifs or Index Match - Text and number formats concatenat
    By DavidW262626 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2017, 02:03 AM
  4. [SOLVED] Formula Sumifs with Index Match not working
    By vba1234 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-15-2016, 06:37 AM
  5. Need help with Sumifs, Index, and match formula!
    By relmasri in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2016, 10:27 AM
  6. [SOLVED] Sumifs/match/index?
    By mstoto in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-14-2014, 09:23 AM
  7. [SOLVED] Dynamic Array, Index & Match, SUMIFS Formula Help!
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-03-2014, 09:27 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