Totals based on meeting multiple criteria

J

JerryS

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
 
R

Roger Govier

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)
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top