need help with formula

J

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
 
S

Soo Cheon Jheong

Hi,

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

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