| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting instances of an incident happening
My worksheet is like this:
A1 A2... 120 210 333 400 510 625 789 801 ...10000 How can I get the how many of the cells the cells have a value between 0 and 400 (in the question above 4), how many times the cells have a value between 401 and 800 (3), etc.? Thanks in advance... Regards, SSM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting instances of an incident happening
=COUNTIF(A1:A100,"<=400")
=COUNTIF(A1:A100,"<=800")-COUNTIF(A1:A100,"<=400") etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "SSM" wrote in message ... My worksheet is like this: A1 A2... 120 210 333 400 510 625 789 801 ...10000 How can I get the how many of the cells the cells have a value between 0 and 400 (in the question above 4), how many times the cells have a value between 401 and 800 (3), etc.? Thanks in advance... Regards, SSM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting instances of an incident happening
Works like a charm!!! Thanks a heap!!!
SSM "Bob Phillips" wrote in message ... =COUNTIF(A1:A100,"<=400") =COUNTIF(A1:A100,"<=800")-COUNTIF(A1:A100,"<=400") etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "SSM" wrote in message ... My worksheet is like this: A1 A2... 120 210 333 400 510 625 789 801 ...10000 How can I get the how many of the cells the cells have a value between 0 and 400 (in the question above 4), how many times the cells have a value between 401 and 800 (3), etc.? Thanks in advance... Regards, SSM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Consecutive Instances | Excel Worksheet Functions | |||
| Counting instances in string | Excel Discussion (Misc queries) | |||
| Counting Multiple Instances | Excel Worksheet Functions | |||
| Counting instances in a cell | Excel Discussion (Misc queries) | |||
| Counting Instances of a Value? | Excel Programming | |||
Hybrid Mode
