View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PaladinWhite PaladinWhite is offline
external usenet poster
 
Posts: 29
Default 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.