R Ravi Dec 5, 2007 #1 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
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 Dec 5, 2007 #2 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))
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))
