Forum Discussion

kresimir.karamarko's avatar
kresimir.karamarko
Copper Contributor
May 16, 2017
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 th...
  • SergeiBaklan's avatar
    May 16, 2017

    Please use 

    ">=" & $W$3 instead of   ">=$W$3"

Resources