| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use CountIf formula to count a within a range of numbers
Use two countif functions as such: =COUNTIF(A1:A50,"<=50")-COUNTIF(A1:A50,"<41") returns the count of items between 41-50 (both inclusive). adjust the range as needed and substitute values to meet your needs. of course, =COUNTIF(A1:A50,"<30") is all you need for your first criteria. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=385614 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Countif to Count Consecutive Relative Increases in Numbers | Excel Discussion (Misc queries) | |||
| countif when range to count is in a different workbook | Excel Discussion (Misc queries) | |||
| Describe high/low range with CountIf (ex. count if >90 and <100 | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
![swatsp0p[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
