Hi
I have three columns and I want to add up the quantity of product abc1 that
was sold in October. I am trying the following formula where B5 is product
abc1, D1 is a cell with 10/1/06 in and D2 is a cell with 10/31/06 in:
=SUMPRODUCT(($A$2:$A$8=B5)*($c$3:$c$8=$D$1<$D$2)* ($b$3:$b$8)).
Currently it is just returning zeros.....

Product Quantity Date
abc1 50 10/20/06
abc2 60 3/21/06
abc3 70 6/20/06
abc1 80 10/3/06
abc1 90 11/11/06
abc2 100 11/12/06

Any help will save my job!