Countif or....

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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,)

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top