ExcelBanter - how do i Count with in the cell range value is 5 and <=15

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i Count with in the cell range value is 5 and <=15 (https://www.excelbanter.com/excel-worksheet-functions/74654-how-do-i-count-cell-range-value-5-%3D15.html)

how do i Count with in the cell range value is 5 and <=15

I have the list given below

27
19
10
22
10
17
22
5
20
3
20
17
10
28
27
12
15
29
33
24
35
10
15
16
12
21
10
16
34
22
17
22
27
26
21
12
15
12
3
20
4
3
15
16
15
15
14
59
15
24
34
13
13
23
11
11
15
4
17
11
23
23
10
13
19
23
14
15
12
28
29
34
25
21
10
11
14
22
11
16
4
12
19
56
30
32
22
29
51
8
32
36
18
2
31
17
79
9
18
18

and i have to count the repeted values i.e
< 5 6 - 15 16 - 25 25 - 50 50 - 75 75
---------------------------------------------------------------------
8 ? ? ? ?
?

can any buddy help me to get the result Please ???

sanjay

how do i Count with in the cell range value is 5 and <=15

=COUNTIF(A:A,"<=15")-COUNTIF(A:A,"<=5")

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sanju" wrote in message
...
I have the list given below

27
19
10
22
10
17
22
5
20
3
20
17
10
28
27
12
15
29
33
24
35
10
15
16
12
21
10
16
34
22
17
22
27
26
21
12
15
12
3
20
4
3
15
16
15
15
14
59
15
24
34
13
13
23
11
11
15
4
17
11
23
23
10
13
19
23
14
15
12
28
29
34
25
21
10
11
14
22
11
16
4
12
19
56
30
32
22
29
51
8
32
36
18
2
31
17
79
9
18
18

and i have to count the repeted values i.e
< 5 6 - 15 16 - 25 25 - 50 50 - 75 75
---------------------------------------------------------------------
8 ? ? ? ?
?

can any buddy help me to get the result Please ???

sanjay