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?
Here is a quicky frequency example that I threw together. I made up a column of numbers and counted the number of values between min nom and max. The frequency formula, function actually, is an array so you have to enter the formula in a special way. select a group of cells that is one greater than the number of subdivisions you have. In this case I have three subdivisions(min,nom,max) so I select 4 cells. With the 4 cells selected type the formula. The first range of cells is the data group, the second range of cells are the subgroup limits. After you enter the formula, CTRL+SHIFT+ENTER to correctly create the array. It will return counts for between 0 and first sub group, first and second subgroup, second and third subgroup, and greater than third subgroup. I know that this is a really cobbled explination and example, if you need more help let me know and I will try to provide when I get a chance.
BTW excell advice from GL??! Isn't that a little dangerous??
Here is a quicky frequency example that I threw together. I made up a column of numbers and counted the number of values between min nom and max. The frequency formula, function actually, is an array so you have to enter the formula in a special way. select a group of cells that is one greater than the number of subdivisions you have. In this case I have three subdivisions(min,nom,max) so I select 4 cells. With the 4 cells selected type the formula. The first range of cells is the data group, the second range of cells are the subgroup limits. After you enter the formula, CTRL+SHIFT+ENTER to correctly create the array. It will return counts for between 0 and first sub group, first and second subgroup, second and third subgroup, and greater than third subgroup. I know that this is a really cobbled explination and example, if you need more help let me know and I will try to provide when I get a chance.
BTW excell advice from GL??! Isn't that a little dangerous??
