I am using countif function in my data. In the function I am using criteria of greater than of a certain value. Now the problem I am facing is, that the criteria value changes for every row and it is very time consuming to change the criteria value for every row. Fore eg. in first Row the function is Counif(A2:BA2,">11"), whereas in Second row Function is Counif(A3:BA3,">8"). Now this criteria value, can come from cell reference. But if I put cell refence, it does not work, becuase of greater than function used in countif. Need help

=COUNTIF(A3:BA3, ">" & A1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll