Totals by type between dates

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

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)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JerryS" <JerryS@discussions.microsoft.com> wrote in message
news:2AB14267-C920-45AC-B4F4-1E375FD94C6D@microsoft.com...
> 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

I didn't equalize the ranges.

Use this instead:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:%23nj4waLFGHA.648@TK2MSFTNGP14.phx.gbl...
> 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)
>
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "JerryS" <JerryS@discussions.microsoft.com> wrote in message
> news:2AB14267-C920-45AC-B4F4-1E375FD94C6D@microsoft.com...
> > 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
>