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

S

sanju

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
(e-mail address removed)
 
B

Bob Phillips

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

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top