Countifs

[Welsh Mark3]

I have a column of values - I'm looking to write a formula that counts how many values fall into each of the following buckets
<500, 501 - 1000, 1001 - 2500, 2501 - 5000, 5001 - 10000, 10001 - 50000, >50000

Can you help me, please?

 

[Joe4]

This shows you exactly how you want to do it: https://exceljet.net/formula/count-cells-between-two-numbers

 

[jproffer]

Like this maybe:

Excel 2013/2016
	A	B	C
1	400		4
2	200		4
3	499		4
4	499		4
5	501		4
6	506		4
7	999		4
8	1000
9	1001
10	1546
11	1932
12	2500
13	2501
14	4000
15	4500
16	5000
17	5001
18	7000
19	9000
20	10000
21	10001
22	20000
23	40000
24	50000
25	60000
26	70000
27	80000
28	90000
Sheet1

Cell Formulas
Range	Formula
C1	=COUNTIF(A1:A28,"<500")
C2	=COUNTIFS(A1:A28,">=501",A1:A28,"<=1000")
C3	=COUNTIFS(A1:A28,">=1001",A1:A28,"<=2500")
C4	=COUNTIFS(A1:A28,">=2501",A1:A28,"<=5000")
C5	=COUNTIFS(A1:A28,">=5001",A1:A28,"<=10000")
C6	=COUNTIFS(A1:A28,">=10001",A1:A28,"<=50000")
C7	=COUNTIF(A1:A28,">50000")