Comparing two columns of numbers

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

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
 
P

PaladinWhite

Perfect - thanks!

Lars-Ã…ke Aspelin said:
Try this, entered as an array formula (CTRL+SHIFT+ENTER rather than
just ENTER):

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

Hope this help / Lars-Ã…ke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top