Totals by type between dates

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

Guest

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
 
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)
 
I didn't equalize the ranges.

Use this instead:

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