SUMPRODUCT, two criteria (date and product type)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks Biff! I really appreciate your help.

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

happy holidays
Bryce
 
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...
 
Back
Top