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?
I have a lot of data points, that is a lot of coding. Here is what I have a column of data. On the same sheet I have the nominal and tolerance. I can set a condition like you said to compare the data in a cell to the nominal. The problem happens when I copy (drag) that formula. It will copy it so that the next cell down gets evaluated which I want but unfortunately the nature of the copy compares it to the next cell down from my nominal. I want it to compare all the cells to my nominal. I can do what you are saying but I'd have to code (or edit) each argument for every cell containing data.
I have a lot of data points, that is a lot of coding. Here is what I have a column of data. On the same sheet I have the nominal and tolerance. I can set a condition like you said to compare the data in a cell to the nominal. The problem happens when I copy (drag) that formula. It will copy it so that the next cell down gets evaluated which I want but unfortunately the nature of the copy compares it to the next cell down from my nominal. I want it to compare all the cells to my nominal. I can do what you are saying but I'd have to code (or edit) each argument for every cell containing data.
