Ooops...misread your post:

=SUMPRODUCT((A1:A5="B OP")*(C1:C5>=D1)*( C1:C5<=D2))
D1 - 01/04/05
D2 - 17/04/05

Regards
JG