need help with formula

[Jay]

How can I take the values in 2 columns and count the number of times that
the value in the first is greater than the value in the second?


example


a b
1 32 24
2 16 96
3 73 21
4 16 54
5 52 18

Number of times that a is greater than b = 3

thanks for your help

Jay

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A20>B1:B20))

 

[Soo Cheon Jheong]

Hi,

=SUMPRODUCT(N(B2:B17>=A2:A17))

--
Regards,
Soo Cheon Jheong
_ _
^ ^
V