If you have the COUNTIFS function, then perhaps:

=COUNTIFS(L6:L5000,">-999",L6:L5000,"<-1",A6:A5000,"<>Complete")
Cheers,