| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thank you. I'll try both methods
"Dave Peterson" wrote: You could count the number = .9 and subtract the ones 1.10 =countif(a1:a10,"=.9") - countif(a1:a10,"1.1") Or you could count the ones that are trapped between those numbers: =SUMPRODUCT(--(A1:A10=0.9),--(A1:A10<1.1)) =sumproduct() likes to work with numbers. The -- converts trues and falses to 1's and 0's. KG wrote: For a range of cells containing percentages, how can I use COUNTIF to count those cells whose values fall between 90% and 110% ? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Counting Numbers in an Interval | Excel Worksheet Functions | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
