I want to count the number instances where column A is between two dates and column B contains a number. The first part is easy.

COUNTIFS(a1:a999,a1:a999,"<"&X,a1:a999">"&Y) ... where x and y are valid dates.

The problem I'm encountering is when I try to add another argument to the above COUNTIFS (i.e. ,b1:b999,"<>" because the non number cells contain a formula) or (,b1:b999,"<0" because the number could be any number including ).

What I really want is to use COUNT with more if arguments.

Thanks to anyone who can solve my challenge.