hexagon logo
Register Sign in
  • Replies 12 replies
  • Subscribers 30 subscribers
  • Views 291 views
  • Users 0 members are here
Options
Related

Excel counting

craiger_ny
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
  • I want to avoid a spreadsheet with shiit all over the place, I'd rather not clutter things. I was able to use replace to fix the formulas instead of editing each one but my goal is to evaluate a name (set of data).

    Oh, sure, change the rules halfway through the game!Angry

    As far as not cluttering, you could always hide the column with the 1's and 0's.

    Thanks man FREQUENCY did it.

    Sounds like you got it.
Reply
  • I want to avoid a spreadsheet with shiit all over the place, I'd rather not clutter things. I was able to use replace to fix the formulas instead of editing each one but my goal is to evaluate a name (set of data).

    Oh, sure, change the rules halfway through the game!Angry

    As far as not cluttering, you could always hide the column with the 1's and 0's.

    Thanks man FREQUENCY did it.

    Sounds like you got it.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement