Hello,

I really need some help with the SUMPRODUCT function. I've never used it
before but i think i could really help me in this situation.

Column A has Product Types (i.e. 1004,1005,1006,1013,...) and column I has
Dates. I want to have to different SUMPRODUCTs. (1) count all product types
based on Product type in cell A6 and the Date in cell A2 located on another
worksheet. (2) The same as sumproduct (1) but do it based on Product type in
cell A6 and between a specified date range imputted as two dates in cell A3
and A4 on another worksheet.

Is this possible?

Thanks and happy holidays,
Bryce