Sumproduct

[osaka78]

a b c d
1 10/2/08 11/2/08 12/2/08
2 xy 5 10 15
3ss 9 12 16

I want to get total if from 11/2/08 to 12/2/08 and ss = 28

 

[Mike H]

try,

=SUMPRODUCT((B11>=DATE(2008,2,11))*(B11<=DATE(2008,2,12))*(A2:A3="ss")*(B23))

Mind the line-wrap, it's all one line.

Mike