Totals based on meeting multiple criteria

I have a sheet that looks something like this:

Date New Old
1/1/06 10
1/5/06 5 5
1/8/06 20
1/8/06 15 5

How do I get a total for New and old between specific dates? For example,
dtotal New between 1/1/06 and 1/5/06?

Thanks
--
JerryS

something like this
=sumproduct((a3:a22>=a1)*(a3:a22<=a2)*b3:b22)

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"JerryS" <JerryS@discussions.microsoft.com> wrote in message
news:58F812C5-6F8E-45C2-BBA3-BF3E63FCB92B@microsoft.com...
>I have a sheet that looks something like this:
>
> Date New Old
> 1/1/06 10
> 1/5/06 5 5
> 1/8/06 20
> 1/8/06 15 5
>
> How do I get a total for New and old between specific dates? For example,
> dtotal New between 1/1/06 and 1/5/06?
>
> Thanks
> --
> JerryS

Hi Jerry

One way
=SUMPRODUCT(--($A$2:$A$100>=DATE(2006,1,1),--($A$2:$A$100<=DATE(2006,1,5),$B$2:$C:100)

--
Regards

Roger Govier


"JerryS" <JerryS@discussions.microsoft.com> wrote in message
news:58F812C5-6F8E-45C2-BBA3-BF3E63FCB92B@microsoft.com...
>I have a sheet that looks something like this:
>
> Date New Old
> 1/1/06 10
> 1/5/06 5 5
> 1/8/06 20
> 1/8/06 15 5
>
> How do I get a total for New and old between specific dates? For
> example,
> dtotal New between 1/1/06 and 1/5/06?
>
> Thanks
> --
> JerryS

=SUMIF(A:A,"<=1/5/2006",B:B)-SUMIF(A:A,"<1/1/2006",B:B)

Vaya con Dios,
Chuck, CABGx3


"JerryS" <JerryS@discussions.microsoft.com> wrote in message
news:58F812C5-6F8E-45C2-BBA3-BF3E63FCB92B@microsoft.com...
> I have a sheet that looks something like this:
>
> Date New Old
> 1/1/06 10
> 1/5/06 5 5
> 1/8/06 20
> 1/8/06 15 5
>
> How do I get a total for New and old between specific dates? For example,
> dtotal New between 1/1/06 and 1/5/06?
>
> Thanks
> --
> JerryS