Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting Age | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |