Results 1 to 8 of 8

Combine SUM, INDEX and MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2018
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    24

    Combine SUM, INDEX and MATCH

    Hello.
    I got some 10000 rows, and if I use SUMIFS the file will hang.
    I'm therefore trying to combine SUM, INDEX and MATCH to sum some rows based upon two criteria's. I've added a demo file.
    What I want to do is to sum the corresponding rows based upon two criteria's and return the sum next to one of the criteria's. If you look at my file, you'll understand what I think.

    I've tried every demo I've found online, but I'm only receiving #NA or #value, so I don't know what I'm doing wrong.

    Can anyone please help me?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combine INDEX(MATCH with INDIRECT (maybe?)
    By sma365 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2017, 04:41 PM
  2. [SOLVED] Combine index match and sumproduct
    By Esrei in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2013, 08:08 AM
  3. [SOLVED] How to combine SUMIF, INDEX and MATCH
    By BeachRock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2013, 04:58 PM
  4. How Do I Combine OFFSET With INDEX MATCH
    By joconnor125 in forum Excel General
    Replies: 8
    Last Post: 06-15-2012, 04:47 AM
  5. [SOLVED] Combine MATCH and INDEX
    By SubwAy in forum Excel General
    Replies: 13
    Last Post: 05-31-2012, 11:53 AM
  6. Replies: 0
    Last Post: 10-10-2011, 07:29 PM
  7. How to combine the INDEX and MATCH functions?
    By Anna A in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2010, 03:47 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