Counting

R

Ravi

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
 
S

Stephen

Ravi said:
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
Click to expand...

One way (adjust range lenth to suit):
=SUMPRODUCT(--(A1:A999>B1:B999))
 
Top