Solved Countif function

December 4, 2011 at 22:19:31
Specs: Windows XP
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

See More: Countif function

Report •

December 5, 2011 at 07:40:52
✔ Best Answer

Report •
Related Solutions

Ask Question