CountIf Function

[Barb Miles]

I have a range of numbers between 1 and 25 in 50 cells.

How could I use the countif function to look at that range of numbers for
values between 5 and 10 and count those values that meet the criteria of
between 5 and 10?

Or if there is another function to use, let me know.

Thank you.
--
Barb

[Swaroon]

Hi, how about something simple like :
Range is 1 to 10
criteria is '>5
criteria is '<11
Use one Countif to work out the answer for values over 5 in the range
Use one Countif to work out the answer for values less than 11
Answer 2 less answer 1 = correct number of values less greater than 5 but less than 11 - sorry, but it's a bit basic !

eg.
1
2
3
4
5
6
7
8
9
10

>5
<11
FORMULA
5 =COUNTIF($A$6:$A$15,A17)
10 =COUNTIF($A$6:$A$15,A18)
5 =+A20-A19