How do I use CountIf formula to count a within a range of numbers

[petevang]

I'd like to know how to use the countIF formula better. I have a pool of 50 returns that I'm trying to group within a couple of ranges. 30 and below, 31 to 40, 41 to 50, 51 to 60, ect... I am using the pool of 50 returns as the range but am having trouble defining the criteria when it comes to looking for numbers that fall between a group, ex 41 to 50.

[swatsp0p]

Use two countif functions as such:

=COUNTIF(A1:A50,"<=50")-COUNTIF(A1:A50,"<41") returns the count of items between 41-50 (both inclusive).

adjust the range as needed and substitute values to meet your needs.

of course, =COUNTIF(A1:A50,"<30") is all you need for your first criteria.

HTH