Lets say I have a column of numbers. I want to know how many are less than a certain value. In other words I need to know the count of cells that pass a certain argument or test for being less than (or greater than for that matter) a certain value. How do I do this?
You could in another column insert an if argument that will return a value of 1 for greater than your set value or 0 for less than your set value. Then, total the column at the bottom. The sum of all the 1's and 0's would be the total number of numbers greater than your limit.
You could in another column insert an if argument that will return a value of 1 for greater than your set value or 0 for less than your set value. Then, total the column at the bottom. The sum of all the 1's and 0's would be the total number of numbers greater than your limit.
