Totals by type between dates

J

JerryS

Columns are as follows:
Order Date Type Quantity
01/05/2006 Red 100
01/06/2006 Blue 100
01/07/2006 Green 100
01/08/2006 Red 100
01/09/2006 Red 100
01/10/2006 Blue 100

I want to add up how many Red were sold between 1/5 and 1/10. Any ideas?
Thanks
 
R

Ragdyer

Say dates in Column A, Type in B, and Qty in C, from A2 to C100.

In D1 enter Type to find,
In D2 enter start date,
In D3 enter end date.

Try this formula:

=SUMPRODUCT((B2:B100=D1)*(A1:A100>=D2)*(A1:A100<=D3)*C1:C100)
 
R

Ragdyer

I didn't equalize the ranges.

Use this instead:

=SUMPRODUCT((B2:B100=D1)*(A2:A100>=D2)*(A2:A100<=D3)*C2:C100)
 
Top