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