=sumproduct((a2:a22a1)*(a2:a22<=b1))
sum
=sumproduct((a2:a22b1)*(a2:a22<=b2)*b2:b22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DP7" wrote in message
...
I have a column that contains dates & quantities I would like to sum based
on
date ranges that I would define. For example I would want the sum
quantities
whose dates fall in-between Nov. 11 & Nov 17. Nov. 18 & 24€¦.. So on & so
forth. I have been trying to figure out a way to do this with maybe a v
lookup or pivot table. However I have not been able to do so. If anyone
has
any ideas as to how I can do what I want to do I would be very grateful.
Thanks in advance.