Comparing two columns of numbers

[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.

 

[Lars-Åke Aspelin]

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.

Try this, entered as an array formula (CTRL+SHIFT+ENTER rather than
just ENTER):

=SUM(- -(A:A>B:B))

Hope this help / Lars-Åke

 

[PaladinWhite]

Perfect - thanks!

Try this, entered as an array formula (CTRL+SHIFT+ENTER rather than
just ENTER):

=SUM(- -(A:A>B:B))

Hope this help / Lars-Ã…ke