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

Matthew D. Hoedeman over 17 years ago

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

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

Sounds like you got it.

Yeah, now he'll have to get the shots for it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Matthew D. Hoedeman over 17 years ago

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

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

Sounds like you got it.

Yeah, now he'll have to get the shots for it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data