# 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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

##### MrExcel MVP
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
0
Views
87
Replies
5
Views
201
Replies
1
Views
151
Replies
2
Views
505
Replies
42
Views
1K

1,148,157
Messages
5,745,105
Members
423,923
Latest member
yuvaraj859

### 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