SUMPRODUCT, two criteria (date and product type)
 

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

SUMPRODUCT, two criteria (date and product type)
 

Try these:

1.

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

2.

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

Biff

"Bryce" wrote in message
...
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

SUMPRODUCT, two criteria (date and product type)
 

Thanks Biff! I really appreciate your help.

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

happy holidays
Bryce



"T. Valko" wrote:

Try these:

1.

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

2.

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

Biff

"Bryce" wrote in message
...
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

SUMPRODUCT, two criteria (date and product type)
 

You're welcome. Thanks for the feedback!

Biff

"Bryce" wrote in message
...
Thanks Biff! I really appreciate your help.

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

happy holidays
Bryce



"T. Valko" wrote:

Try these:

1.

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

2.

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

Biff

"Bryce" wrote in message
...
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