| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - count if a number falls within an array in a column & add
Trying to write a formula that creates a count if a number in a cell in an
array (a column) falls within a certain range, and then adds them up: e.g. 1.9 1 3.2 0.5 I want to count if a number is greater (or equal) to 0.5 but less than 2, and then add them up to return a value (3). I've tried IF, COUNTIF, AND, OR but can't get it to work - Any ideas? Nigel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count array for top three entries and return their number | Excel Discussion (Misc queries) | |||
| Excel - find where a number falls in a start and end range | New Users to Excel | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| how to count if the value falls between a date range | Excel Discussion (Misc queries) | |||
| Formula to count number of dates in an array | Excel Worksheet Functions | |||
Threaded Mode
