ExcelBanter - Counting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting (https://www.excelbanter.com/excel-discussion-misc-queries/168511-counting.html)

Ravi

Counting

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

Stephen[_2_]

Counting

"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))

All times are GMT +1. The time now is 08:44 PM.