countif(B6:B35,"0<11")

One way, try:
=COUNTIF($B$6:$B$35,"0")-COUNTIF($B$6:$B$35,"=11")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mhz" wrote:

Don't want to sound silly here, but I am actually having a problem with
a formula that will allow me to count only values greater than 0 but
less than 11. Is this Possible in 1 unique formula? Heres the
situation:

Within Column B6:B35, I want a count of any number that is greater
than 0 but less than 11. I tried the following but it returns a 0:

countif(B6:B35,"0<11")

Thanks In Advance for any help here...


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=561009