View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sanju
 
Posts: n/a
Default 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