Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif using a range
Hi All
Trying to use countif on a range, say my data is below: 5.4 5.3 5.1 5.1 5 4.9 4.9 4.3 4 3.8 I want to have the following 5+ 5 4-5 4 etc... for the 1st one its no prob, I have the following countif =COUNTIF(CompDbl!C2:C96,"=5") but for the next one and below I need to be able to count if the value is between 2 values, I tried this but no joy: =COUNTIF(CompDbl!C2:C96,"=4"&"<=4.99") I'd appreciate any help anyone can provide, can this even be done using countif?? thanks gR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Countif for specific cells rather than a range ???? | Excel Worksheet Functions |