| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif number between x and y
Have a column of figures and want to countif the value in cell falls between
x or y That is countif(e:e, 5 or <10) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Countif number between x and y
Hi Bill
Try =COUNTIF(A:A,"5")-COUNTIF(A:A,"=10") OR =SUMPRODUCT((A1:A1005)*(A1:A100<10)) -- Jacob (MVP - Excel) "Bill" wrote: Have a column of figures and want to countif the value in cell falls between x or y That is countif(e:e, 5 or <10) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF SPECIAL NUMBER | Excel Discussion (Misc queries) | |||
| COUNTIF across a number of worksheets | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Countif to always get a positive number | Excel Discussion (Misc queries) | |||
| Countif using Wildcard * and number 1 | Excel Worksheet Functions | |||
Linear Mode
