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:
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")