I didn't equalize the ranges.

Use this instead:

=SUMPRODUCT((B2:B100=D1)*(A2:A100=D2)*(A2:A100<=D 3)*C2:C100)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
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<=D 3)*C1:C100)

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"JerryS" wrote in message
...
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
--
JerryS