Let's say I'm trying to count the number of rows where the value in column A is greater than in column B and the data I have is that A1 to A10 has the numbers 1 up to 10 and B1 to B10 has the numbers 10 down to 1.
The forumula I've constructed is
=COUNTIF(A1:A10, ">"&B1:B10)
The correct result would be 5 but if I place this formula in row 10 I get the result of 9. Also, I get different results if I place this exact same function in different cells.
It seems to be the cell references as the second parameter that breaks the function as something like =COUNTIF(A1:A10, ">4")
works fine.