P
PaladinWhite
My ColA and ColB contain arbitrary integers, either positive, zero, or
negative. I'm trying to count the number of times that the value in a given
row of ColA is greater than that in ColB. For instance, for these data:
1 | 4
2 | -1
3 | 7
4 | -3
5 | 0
.... I need to return a three (the values in rows 2, 4, and 5 of ColA are
greater than those of ColB).
I tried COUNTIF(A:A,"<B:B"), with no luck. I get a zero value, no matter the
appropriate return.
negative. I'm trying to count the number of times that the value in a given
row of ColA is greater than that in ColB. For instance, for these data:
1 | 4
2 | -1
3 | 7
4 | -3
5 | 0
.... I need to return a three (the values in rows 2, 4, and 5 of ColA are
greater than those of ColB).
I tried COUNTIF(A:A,"<B:B"), with no luck. I get a zero value, no matter the
appropriate return.