# Countif or....

#### imported_unknown

##### Active Member
What is an example of the formula to:
Count the number of times a number appears in a list within a range.

for example,

Item List
50
35
34
32
50
45
50

The criteria range is:
Range:

<=5
6 to 10
11 to 19
20 to 29
30 to 39
40 to 49
50 to 59

etc

I would like to know a count of how many numbers fall with the above ranges.

Tks.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
The<=5 spec appears to mean "from 0 to 5 inclusive".

The essetial formula is:

=COUNTIF(\$A\$2:\$A\$8,">="&C2)-COUNTIF(\$A\$2:\$A\$8,">="&C3)
where A2:A8 houses the numbers to count, C2 the lower limit, and C3 the upper limit such that the latter is the lower limit of the next between condition...

See the figure...
aaBetweenConditionCounting excelsmarts.xls
ABCDE
1ItemListFromToCount
250050
3356100
43411190
53220290
65030393
74540491
85050593
Sheet1

Replies
2
Views
130
Replies
2
Views
98
Replies
3
Views
272
Replies
2
Views
431
Replies
14
Views
345

1,219,688
Messages
6,149,725
Members
450,910
Latest member
DianeG

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back