| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Formula
I'm trying to count the number of cells which contain values within a given
range. For example, I want to count all the cell in a column which contain a value between 50,000 and 100,000. I've tried using the Countif formula given as an example by microsoft but the results are wrong. The formula looks like this: countif(y2:y268, "=50000")-countif(y2:y268, "<=100000") Does anyone know why I'm getting the wrong results and is there another way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a range name in formula | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| Sum Formula that excludes other sum formula in range | Excel Worksheet Functions | |||
| use range name in formula | Excel Worksheet Functions | |||
Threaded Mode
