count formula

[Tripleseas]

hello community,
I have a column of pourcentage and i want to count the number of theses percentages based on ranges as shown below. is there any formula that can do this.
thanks

Classeur1
	A	B	C	D	E	F
1	TRO				Baromètre
2	5%
3	3%				0% - 10%
4	11%				11% - 30%
5	11%				31 % - 49%
6	13%				>= 50%
7	4%
8	6%
9	16%
10	9%
11	7%
12	5%
13	8%
14	5%
15	8%
16	12%
17	5%
18	14%
19	11%
20	21%
21	9%
22	4%
23	4%
24	7%
25	6%
26	10%
27	12%
28	3%
29	5%
30	8%
31	13%
32	8%
33	7%
34	9%
35	8%
36	6%
37	11%
38	6%
39	5%
40	9%
41	7%
42	19%
43	3%
44	6%
45	19%
46	8%
47	13%
48	8%
49	10%
50	3%
51	4%
52	7%
53	4%
54	10%
55	1%
56	4%
57	4%
58	8%
59	4%
60	4%
61	6%
62	7%
63	7%
64	8%
65	4%
66	3%
67	4%
68	7%
69	10%
70	9%
71	12%
72	4%
73	4%
74	13%
75	10%
76	4%
77	8%
78	7%
79	2%
80	5%
81	5%
82	5%
83	7%
84	7%
85	4%
86	6%
87	8%
88	9%
89	7%
90	12%
91	7%
92	5%
93	4%
94	7%
95	7%
96	6%
97	11%
98	12%
99	7%
100	4%
101	3%
102	2%
103	4%
104	10%
105	3%
106	3%
107	6%
108	4%
109	7%
110	1%
111	2%
112	6%
113	5%
114	10%
115	17%
116	6%
117	9%
118	5%
119	8%
120	5%
121	4%
122	6%
123	14%
124	2%
125	7%
126	9%
127	5%
128	13%
129	7%
130	16%
131	7%
132	5%
133	14%
134	2%
135	9%
136	7%
137	5%
138	4%
139	11%
140	5%
141	5%
142	4%
143	1%
144	3%
145	6%
146	4%
147	4%
148	8%
149	5%
150	2%
151	2%
152	9%
153	5%
154	5%
155	11%
156	9%
157	8%
158	9%
159	4%
160	3%
161	2%
162	8%
163	11%
164	10%
165	14%
166	3%
167	9%
168	3%
169	3%
170	5%
171	5%
172	5%
173	4%
174	10%
175	2%
176	3%
177	3%
178	2%
179	4%
180	4%
181	5%
182	5%
183	7%
184	3%
185	2%
186	3%
187	9%
188	5%
189	7%
190	2%
191	6%
192	3%
193	11%
194	8%
195	7%
196	5%
197	4%
198	11%
199	5%
200	9%
201	8%
202	17%
203	2%
204	9%
205	9%
206	5%
207	6%
208	9%
209	6%
210	9%
211	11%
212	8%
213	17%
214	6%
215	7%
216	7%
217	3%
218	2%
219	8%
220	7%
Feuil1

 

[Joe4]

You can use the COUNTIFS function to do that.
See here for details and examples: Excel COUNTIFS and COUNTIF with multiple AND / OR criteria - formula examples
Specifically, see the section entitled "Count numbers between X and Y".

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	TRO				Baromètre
2	5%
3	3%				0% - 10%	183
4	11%				11% - 30%	36
5	11%				31 % - 49%	0
6	13%				>= 50%	0
7	4%
8	6%
9	16%
10	9%
11	7%
12	5%
13	8%
14	5%
15	8%
16	12%
17	5%
18	14%
19	11%
20	21%
21	9%
22	4%
23	4%
24	7%
25	6%
26	10%
27	12%
28	3%
29	5%
30	8%
31	13%
32	8%
33	7%
34	9%
35	8%
36	6%
37	11%
38	6%
39	5%
40	9%
41	7%
42	19%
43	3%
44	6%
45	19%
46	8%
47	13%
48	8%
49	10%
50	3%
51	4%
52	7%
53	4%
54	10%
55	1%
56	4%
57	4%
58	8%
59	4%
60	4%
61	6%
62	7%
63	7%
64	8%
65	4%
66	3%
67	4%
68	7%
69	10%
70	9%
71	12%
72	4%
73	4%
74	13%
75	10%
76	4%
77	8%
78	7%
79	2%
80	5%
81	5%
82	5%
83	7%
84	7%
85	4%
86	6%
87	8%
88	9%
89	7%
90	12%
91	7%
92	5%
93	4%
94	7%
95	7%
96	6%
97	11%
98	12%
99	7%
100	4%
101	3%
102	2%
103	4%
104	10%
105	3%
106	3%
107	6%
108	4%
109	7%
110	1%
111	2%
112	6%
113	5%
114	10%
115	17%
116	6%
117	9%
118	5%
119	8%
120	5%
121	4%
122	6%
123	14%
124	2%
125	7%
126	9%
127	5%
128	13%
129	7%
130	16%
131	7%
132	5%
133	14%
134	2%
135	9%
136	7%
137	5%
138	4%
139	11%
140	5%
141	5%
142	4%
143	1%
144	3%
145	6%
146	4%
147	4%
148	8%
149	5%
150	2%
151	2%
152	9%
153	5%
154	5%
155	11%
156	9%
157	8%
158	9%
159	4%
160	3%
161	2%
162	8%
163	11%
164	10%
165	14%
166	3%
167	9%
168	3%
169	3%
170	5%
171	5%
172	5%
173	4%
174	10%
175	2%
176	3%
177	3%
178	2%
179	4%
180	4%
181	5%
182	5%
183	7%
184	3%
185	2%
186	3%
187	9%
188	5%
189	7%
190	2%
191	6%
192	3%
193	11%
194	8%
195	7%
196	5%
197	4%
198	11%
199	5%
200	9%
201	8%
202	17%
203	2%
204	9%
205	9%
206	5%
207	6%
208	9%
209	6%
210	9%
211	11%
212	8%
213	17%
214	6%
215	7%
216	7%
217	3%
218	2%
219	8%
220	7%
Temp

Cell Formulas
Range	Formula
F3	F3	=COUNTIFS(A:A,"<=10%")
F4	F4	=COUNTIFS(A:A,">10%",A:A,"<=30%")
F5	F5	=COUNTIFS(A:A,">30%",A:A,"<50%")
F6	F6	=COUNTIFS(A:A,">=50%")

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Temp!$A$1:$A$220	F3:F6

 

[Tripleseas]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	TRO				Baromètre
2	5%
3	3%				0% - 10%	183
4	11%				11% - 30%	36
5	11%				31 % - 49%	0
6	13%				>= 50%	0
7	4%
8	6%
9	16%
10	9%
11	7%
12	5%
13	8%
14	5%
15	8%
16	12%
17	5%
18	14%
19	11%
20	21%
21	9%
22	4%
23	4%
24	7%
25	6%
26	10%
27	12%
28	3%
29	5%
30	8%
31	13%
32	8%
33	7%
34	9%
35	8%
36	6%
37	11%
38	6%
39	5%
40	9%
41	7%
42	19%
43	3%
44	6%
45	19%
46	8%
47	13%
48	8%
49	10%
50	3%
51	4%
52	7%
53	4%
54	10%
55	1%
56	4%
57	4%
58	8%
59	4%
60	4%
61	6%
62	7%
63	7%
64	8%
65	4%
66	3%
67	4%
68	7%
69	10%
70	9%
71	12%
72	4%
73	4%
74	13%
75	10%
76	4%
77	8%
78	7%
79	2%
80	5%
81	5%
82	5%
83	7%
84	7%
85	4%
86	6%
87	8%
88	9%
89	7%
90	12%
91	7%
92	5%
93	4%
94	7%
95	7%
96	6%
97	11%
98	12%
99	7%
100	4%
101	3%
102	2%
103	4%
104	10%
105	3%
106	3%
107	6%
108	4%
109	7%
110	1%
111	2%
112	6%
113	5%
114	10%
115	17%
116	6%
117	9%
118	5%
119	8%
120	5%
121	4%
122	6%
123	14%
124	2%
125	7%
126	9%
127	5%
128	13%
129	7%
130	16%
131	7%
132	5%
133	14%
134	2%
135	9%
136	7%
137	5%
138	4%
139	11%
140	5%
141	5%
142	4%
143	1%
144	3%
145	6%
146	4%
147	4%
148	8%
149	5%
150	2%
151	2%
152	9%
153	5%
154	5%
155	11%
156	9%
157	8%
158	9%
159	4%
160	3%
161	2%
162	8%
163	11%
164	10%
165	14%
166	3%
167	9%
168	3%
169	3%
170	5%
171	5%
172	5%
173	4%
174	10%
175	2%
176	3%
177	3%
178	2%
179	4%
180	4%
181	5%
182	5%
183	7%
184	3%
185	2%
186	3%
187	9%
188	5%
189	7%
190	2%
191	6%
192	3%
193	11%
194	8%
195	7%
196	5%
197	4%
198	11%
199	5%
200	9%
201	8%
202	17%
203	2%
204	9%
205	9%
206	5%
207	6%
208	9%
209	6%
210	9%
211	11%
212	8%
213	17%
214	6%
215	7%
216	7%
217	3%
218	2%
219	8%
220	7%
Temp

Cell Formulas
Range	Formula
F3	F3	=COUNTIFS(A:A,"<=10%")
F4	F4	=COUNTIFS(A:A,">10%",A:A,"<=30%")
F5	F5	=COUNTIFS(A:A,">30%",A:A,"<50%")
F6	F6	=COUNTIFS(A:A,">=50%")

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Temp!$A$1:$A$220	F3:F6

thank you working good

 

[Fluff]

You're welcome & thanks for the feedback.