+ Reply to Thread
Results 1 to 4 of 4

Advanced! Sum Qty Shipped to a referenced product between 2 historical date. Index/Match

  1. #1
    Registered User
    Join Date
    11-09-2019
    Location
    Toronto, Ontario
    MS-Off Ver
    Office 365
    Posts
    2

    Wink Advanced! Sum Qty Shipped to a referenced product between 2 historical date. Index/Match

    Dear users,

    Please try and help me solve this long time riddle. I have exhausted all my talent and resources.

    Instructions are inside collector workbook.
    Solution requested will be in Collector.xlsx workbook in cells G2:J2
    My guess it has some combination of if, sumif, sumproduct, greater, less then, equal to, and type nested function that does index and matching the tree type and the date with the data in Samples.xlsx

    Note: VLOOK or HLOOK will break due to the Samples workbook having blanks in 2 cells. Need index/match? I have all sort of index and matching formulas but have figured out sumproductif the referenced trees falls between 2 dates in another workbook.



    thanks
    jr logger
    Attached Files Attached Files
    Last edited by JuniorLogger19; 11-16-2019 at 04:09 PM.

  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: Advanced! Sum Qty Shipped to a referenced product between 2 historical date. Index/Mat

    Take a look at using sumifS() for this
    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
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Advanced! Sum Qty Shipped to a referenced product between 2 historical date. Index/Mat

    with both workbooks open.

    Use EDATE to calculate prior datres:
    Please Login or Register  to view this content.
    prior year:
    Please Login or Register  to view this content.
    -9 mos, etc...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by protonLeah; 11-17-2019 at 01:10 AM.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    11-09-2019
    Location
    Toronto, Ontario
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Advanced! Sum Qty Shipped to a referenced product between 2 historical date. Index/Mat

    Thank you very much. I just did a quick check and looks great so far. I will mark complete soon.

+ 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] List out historical data with INDEX x MATCH x ?
    By pcgk33 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-14-2018, 04:19 AM
  2. Replies: 5
    Last Post: 02-26-2017, 04:46 PM
  3. [SOLVED] INDEX MATCH as arrayfunction using MAX and PRODUCT
    By Sherk in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-06-2016, 08:48 AM
  4. Replies: 3
    Last Post: 10-28-2015, 09:54 AM
  5. Inventory - Marking stock that has shipped as shipped.
    By CJ2308 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2015, 03:35 PM
  6. [SOLVED] Index match with min and sum product
    By lejanco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-16-2014, 01:01 PM
  7. Need data cross-referenced in multiple tables: VLOOKUP vs. Match vs. Index
    By James McMurray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2008, 02:53 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1