| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances in a range
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.worksheet.functions
|
|||
|
|||
|
Counting number of instances in a range
=COUNTIF(B1:B8,"<=400") (assuming all numbers are positive) =COUNTIF(B1:B8,"=401")-COUNTIF(B1:B8,"800") HTH "SSM" wrote: 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.worksheet.functions
|
|||
|
|||
|
Counting number of instances in a range
Here's one (somewhat non-standard) way:
0-400: =SUM((COUNTIF(A1:A10,{"=0","400"})*{1,-1})) 401-800: =SUM((COUNTIF(A1:A10,{"=401","800"})*{1,-1})) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "SSM" wrote: 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 | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
