+ Reply to Thread
Results 1 to 5 of 5

INDEX-MATCH with Multiple Row Criteria?

Hybrid View

  1. 03-26-2020, 02:50 PM #1
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: INDEX-MATCH with Multiple Row Criteria?

    How about
    =SUMIFS($C$3:$C$11,$A$3:$A$11,F$2,$B$3:$B$11,$E3)
    Reply With QuoteRegister To Reply
  2. 03-27-2020, 10:58 AM #2
    eNinjaInTraining
    eNinjaInTraining is offline
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    MS365
    Posts
    80

    Re: INDEX-MATCH with Multiple Row Criteria?

    Thanks for the help, Fluff13 and avk!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 with multiple criteria when one criteria requires to exclude values from searc
    By adsako in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2020, 08:06 AM
  2. Index Match based on multiple Match criteria that returns each subsequent occurence.
    By punkrocksock in forum Excel General
    Replies: 1
    Last Post: 03-01-2020, 10:36 PM
  3. INDEX MATCH from table with multiple MATCH criteria
    By nostrum in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2019, 11:41 AM
  4. [SOLVED] Index match with multiple criteria, with one criteria being greater than a certain date
    By Dord25 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  5. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  6. 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
  7. Formula needed for partial string match as part of index match with multiple criteria
    By Marvelous in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2014, 04:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1