SUMPRODUCT, two criteria (date and product type)

[Guest]

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

 

[T. Valko]

Try these:

1.

=SUMPRODUCT(--(Product_range=A6),--(Date_range=other_sheet!A2))

2.

=SUMPRODUCT(--(Product_range=A6),--(Date_range>other_sheet!A3),--(Date_range<other_sheet!A4))

Biff

 

[Guest]

Thanks Biff! I really appreciate your help.

Both formulas work perfectly. I can't thank you enough.

happy holidays
Bryce

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks Biff! I really appreciate your help.

Both formulas work perfectly. I can't thank you enough.

happy holidays
Bryce