Hi guys,
I have a little problem counting how many cells have a value between two other cells.
I tried this: =COUNTIF(B2:B101;">B101") - COUNTIF(B2:B101;">B102").
This doesn't seem to work. However, if I specify the limit numbers, say =COUNTIF(B2:B101;">19")-COUNTIF(B2:B101;">25"), then it does work.
Does someone know why this happens, and if there is a better solution than copying the specific values?
Thanks!
Bookmarks