SUMPRODUCT, two criteria (date and product type)

B

Bryce

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

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
 
B

Bryce

Thanks Biff! I really appreciate your help.

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

happy holidays
Bryce
 
T

T. Valko

You're welcome. Thanks for the feedback!

Biff

Bryce said:
Thanks Biff! I really appreciate your help.

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

happy holidays
Bryce
Click to expand...
 
Top