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

1. ## 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

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

Take a look at using sumifS() for this

3. ## 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.``

4. ## 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.

#### Thread Information

##### Users Browsing this Thread

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

#### 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