hexagon logo

Excel counting

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?
Parents
  • 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'll be goddamed, that works!


    You doubted me? Slight smile

    I have had to teach myself Excel & Visual Basic so I could get through many jobs. Ive came up with some slick templates & post processers. If you have any other issues ever, let me know, I would be happy to help.
Reply
  • 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'll be goddamed, that works!


    You doubted me? Slight smile

    I have had to teach myself Excel & Visual Basic so I could get through many jobs. Ive came up with some slick templates & post processers. If you have any other issues ever, let me know, I would be happy to help.
Children
No Data