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
--
Swaroon
------------------------------------------------------------------------
Swaroon's Profile:
http://www.excelforum.com/member.php...o&userid=36527
View this thread:
http://www.excelforum.com/showthread...hreadid=562473