Forum Discussion
Solved
Countif function
Hi, I have a problem with countif function. When criteria is linked to a cell which is a formula, it returns 0. If I change it to a fixed number than it works.
=COUNTIF(R3:R19;">=$W$3")
In the cell w3 I have this formula =LARGE(Q3:V19;17)
Please use
">=" & $W$3 instead of ">=$W$3"
2 Replies
Please use
">=" & $W$3 instead of ">=$W$3"
It works! Thank you so much!
