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?

Matthew D. Hoedeman over 16 years ago

why not use a formula like:

=COUNTIF(A1:A2000,">15")

Assuming your data is in column A & you want to count how many numbers are greater then 15.

I'll be goddamed, that works! REP for you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Jeff Hunt over 16 years ago

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?

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel