Comparing two columns of numbers
 

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.

Comparing two columns of numbers
 

On Sun, 1 Jun 2008 14:48:00 -0700, PaladinWhite
wrote:

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:AB:B))

Hope this help / Lars-Åke

Comparing two columns of numbers
 

Perfect - thanks!

"Lars-Ã…ke Aspelin" wrote:

On Sun, 1 Jun 2008 14:48:00 -0700, PaladinWhite
wrote:

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:AB:B))

Hope this help / Lars-Ã…ke