I'd like to be able to count between a range of numbers (which I think I've solved below). However, along with that I also need the the formula to look at the cells in column A and if any of the cells contain the word, "Complete" then I'd like for the formula not count that piece of data in column L.

This is what I have so far.

=ABS(COUNTIF(L6:L5000,"<-999")-COUNTIF(L6:L5000,"<-1"))

I just need to figure out how to exclude a cell in the countif logic, as long as the word in column A = "Complete"