COUNTIFS / COUNT combined?

[ko1967]

I have 2 columns. Column A contains dates. Column B contains a formula that populates a value based on other criteria. Once the criteria in the formula and a value is present in column B I cut/paste the value into the same cell so that column B contains a bunch of formulas or values (i.e. numbers).

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.

 

[Tetra201]

Will this work for you?

=SUMPRODUCT(--($A$1:$A$999>Y1),--($A$1:$A$999 < X1),--ISNUMBER($B$1:$B$999))<x1),--isnumber($b$1:$b$999))< html=""></x1),--isnumber($b$1:$b$999))<>

 

[ko1967]

Winner winner chicken dinner. That worked Tetra. Thanks so much. I need to keep in mind sumproduct when I want complex counting.

 

[Tetra201]

You are welcome.

 

[Aladin Akyurek]

Using a well-known constant of Excel, we can reasonably duplicate an array-processing approach with COUNTIFS...

=COUNTIFS($A$1:$A$999,">"&Y1,$A$1:$A$999,"<"&$X$1,$B$1:$B$999,"<="&9.99E+307)