COUNTIF to return number of values less than an iterating number?

[DannyRedd]

So I'm trying to count how many numbers in a given range are less than one and get it to return in the first cell, and how many numbers in the same range are less than two to be displayed in the next cell for around 90 cells. How can I do this? Normally, I just click and drag but it's not working this time...

This is the closest I'm getting.

=COUNTIF($A$2:$A$89, "<3")

But what I want is the 3 to change for every cell. Any suggestions?

[Moo the Dog]

You can try this:

=COUNTIF($A$2:$A$89,"<"&ROWS($A$1:$A1))

Then fill down. That will change from 1, to 2, then to 3, etc. for as many rows as you fill down.

- Moo

[Tsjallie]

Would this do what you need?

[DannyRedd]

Awesome, that worked perfectly Moo the Dog! Thank you!

[Moo the Dog]

You're quite welcome. Glad to help!
- Moo

- - - - - - - - - -
Feel free to click on the small star at the lower left corner of one of my posts if you feel my answer has solved your question. It's always appreciated!