BrutalDawg
New Member
- Joined
- Jun 10, 2015
- Messages
- 41
I am having trouble creating a viable formula that will sum the product found on the sheet1 within a certain date range.
I would like to enable it as a vlookup. Essentially, look for item one sheet1, and total sum within the month.
Similar to below.
Sheet1:
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
Sheet2 with desired results:
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
formula in sheet 2 for apr,may,jun etc. would look for corresponding item on sheet1, and total the qty within that particular month.
Thanks for any help or suggestions
I would like to enable it as a vlookup. Essentially, look for item one sheet1, and total sum within the month.
Similar to below.
Sheet1:
Location | Issue | SI | Item | Time | Qty | When |
Ohio | 4/10/2018 | 123 | Firm | 10 | 4/9/2018 | |
Ohio | 4/10/2018 | 321 | Firm | 10 | 4/9/2018 | |
Ohio | 4/10/2018 | 567 | Firm | 10 | 4/9/2018 | |
Ind | 4/10/2018 | 123 | Firm | 15 | 4/16/2018 | |
Ind | 4/10/2018 | 321 | Firm | 15 | 4/16/2018 | |
Ind | 4/10/2018 | 567 | Firm | 15 | 4/16/2018 | |
NO | 4/10/2018 | 123 | Forecast | 10 | 5/1/2018 | |
NO | 4/10/2018 | 321 | Forecast | 10 | 5/1/2018 | |
NO | 4/10/2018 | 567 | Forecast | 10 | 5/1/2018 |
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
Sheet2 with desired results:
Item | April | May | June | Jul |
123 | 25 | 10 | 0 | 0 |
321 | 25 | 10 | 0 | 0 |
567 | 25 | 10 | 0 | 0 |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
formula in sheet 2 for apr,may,jun etc. would look for corresponding item on sheet1, and total the qty within that particular month.
Thanks for any help or suggestions