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

Totals based on meeting multiple criteria
 

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

--
Don Guillett
SalesAid Software

"JerryS" wrote in message
...
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

Totals based on meeting multiple criteria
 

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" wrote in message
...
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

Totals based on meeting multiple criteria
 

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

Vaya con Dios,
Chuck, CABGx3


"JerryS" wrote in message
...
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