Try this:

=SUMPRODUCT((A2:A6=1)*(B2:B6="del")*(C2:C6=FALSE)*(C2:C6<>""))

HTH

Jason