Forum Discussion
kresimir.karamarko
May 16, 2017Copper Contributor
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 th...
- May 16, 2017
Please use
">=" & $W$3 instead of ">=$W$3"
SergeiBaklan
May 16, 2017Diamond Contributor
Please use
">=" & $W$3 instead of ">=$W$3"
- kresimir.karamarkoMay 16, 2017Copper Contributor
It works! Thank you so much!