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