+ Reply to Thread
Results 1 to 5 of 5

SUMIF with INDEX MATCH between 2 dates

  1. #1
    Registered User
    Join Date
    03-20-2017
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    2

    SUMIF with INDEX MATCH between 2 dates

    I have multiple stores within various town and want to be able to summarise the profits earned between two dates by town.

    I’m using the formula
    SUMIF(INDEX($C$2:$P$7,,MATCH(A14,$A$2:$A$7,0)),$C$1:$P$1,”>=”&$B$10,$C$1:$P$1,”<=”&$B$11)
    This is returning a VALUE error.

    Below is how my worksheet has been set-up. I’ve seen similar queries on other threads but none of the solutions provided seem to fix my problem.
    Attached Files Attached Files
    Last edited by FueledbyExcel; 11-01-2019 at 10:37 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,006

    Re: SUMIF with INDEX MATCH between 2 dates

    Try: =SUMPRODUCT(($A$2:$A$7=A14)*($C$1:$O$1>=$B$10)*($C$1:$O$1<=$B$11),$C$2:$O$7)
    Click the * to say thanks.

  3. #3
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: SUMIF with INDEX MATCH between 2 dates

    Use this, instead:

    =SUMPRODUCT(($C$1:$O$1>=$B$10)*($C$1:$O$1<=$B$11)*($A$2:$A$7=A14)*$C$2:$O$7)
    Glenn



  4. #4
    Registered User
    Join Date
    03-20-2017
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    2

    Re: SUMIF with INDEX MATCH between 2 dates

    Both of these solutions work absolutely brilliantly. Thanks for the quick response.

  5. #5
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: SUMIF with INDEX MATCH between 2 dates

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. [SOLVED] Index Match SumIf Approximate Match
    By hnguy71 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2019, 06:26 PM
  2. Need help today please! Sumif, index, index match
    By helpmeplz_ in forum Excel General
    Replies: 2
    Last Post: 08-26-2017, 12:50 PM
  3. Index Match to find match date to a range of dates
    By downcrusher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 06:05 PM
  4. Sumif / Index Match - Sum together between two dates
    By jonesm2 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-09-2017, 12:18 PM
  5. Sumif or Index/Match on Multiple Criteria including Dates to Month?
    By patrick1024 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2015, 11:00 PM
  6. Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  7. Index Match and SUMIF
    By xirokx in forum Excel General
    Replies: 3
    Last Post: 09-05-2008, 09:18 AM

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