| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Greater Than / Less Than Problem
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Startup Problem | Excel Discussion (Misc queries) | |||
| Problem with MS Community Newsgroups? | Excel Discussion (Misc queries) | |||
| Problem with compound IF statement | Excel Worksheet Functions | |||
| Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
