| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count if a cell value falls between two numbers
I tried to write a formula to count how often the value of a range of cells
falls between two numbers. for example in the chart below: row value 1 25 2 27 3 36 4 37 5 42 I tried the formula =countif(a1:a5,and(35,<40)) and my result was "0" when it should be "2". Can anyone help correct my formula? thanks glenn -- Glenn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL | Excel Discussion (Misc queries) | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| 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) | |||
| get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
Threaded Mode
