| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater than # but less than #
Your example does not define a range (or at least not the kind I think you
are looking for) as they both specify less than type conditions. Also, one is a percentage and the other is not. However, if you have a range such as =2 and <9, you could use this to count it... =SUMPRODUCT((A1:A10=2)*(A1:A10<9)) Just change the 2 and 9 values and the logical operator combinations to match your requirements. Rick "ph3nom3nalwoman" wrote in message ... I want to do a count of how many #'s are between this %range (ex <=80%, <+99) I am not having any luck doing this. Any help would be great! thanks -- PH3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| greater than.. | Excel Discussion (Misc queries) | |||
| I have Greater than, I need less than also | Excel Worksheet Functions | |||
| if value is greater than # * by 20% if less * by 40 | New Users to Excel | |||
| Greater Than but Less than | Excel Worksheet Functions | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
![Rick Rothstein \(MVP - VB\)[_527_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
