How to use COUNTIFS with multiple conditions and columns in Excel

Question

In Excel, I'm attempting to use COUNTIFS to count the number of values based on several conditions and numerous columns. This is an illustration of what I'm attempting:

ColumnA        ColumnB
16             12.4
-              2
15             -
8              -
-              25
-              12
20             23
15             19
12.5           10 

When ColumnA exceeds 12.5 and when each value in ColumnB exceeds the equivalent value in the same row when compared to ColumnA, those are the conditions I'm looking to look for. Because only two rows in ColumnA have a value more than 12.5 and where the matching value in ColumnB is greater than the value in ColumnA, the count in the sample data shown above should be 2.

I've tried this but it's giving me a 0 count,

=COUNTIFS(A1:A9, ">12.5", B1:B9, ">A1:A9")

Answer 1

Use  SUMPRODUCT and double unay operators:

=SUMPRODUCT(--(A1:A9>12.5)*--(B1:B9>A1:A9)*--(ISNUMBER(B1:B9)))