"Ravi" wrote in message
...
I am trying to count how many times the value in Col A has exceeded the
value
in Col B in a given range, How to get this

One way (adjust range lenth to suit):
=SUMPRODUCT(--(A1:A999B1:B999))