| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting with multiple conditions
The below formula is working in macro.
myvar= "=countif(a1:a100,10)" but i need to count the cells containing values between less than 10 and greater than five? How to change the above formula to incorporate this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting with multiple conditions
The below formula is working in macro.
myvar= "=countif(a1:a100,10)" but i need to count the cells containing values between less than 10 and greater than five? How to change the above formula to incorporate this? How about this... myvar= "=countif(a1:a100,""<10"")-countif(a1:a100,""<=5"")" Note that this excludes 5 and 10 from the range. If you want to include them, add an equal sign to the '<10' and remove the equal sign from the '<=5'. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting for multiple conditions | Excel Worksheet Functions | |||
| Help with counting multiple conditions | Excel Discussion (Misc queries) | |||
| Counting with multiple conditions | Excel Programming | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
Hybrid Mode
