Hi Ahmad,
Not sure if I'm clear on what you want as I counted 6 rows with the number
1. The others weren't right either.

However, I think what you need is this formula (1 for each number you want
to count).
=COUNTIF($A$1:$A$15,1)
=COUNTIF($A$1:$A$15,2)
=COUNTIF($A$1:$A$15,3)
(Assuming your data is in A1 to A15.)

That will give you the count but if you want it to appear as
1=6 Rows, etc., you will need to format each cell as Custom using the
following as appropriate:
1=0 "rows".
2=0 "rows"
3=0 "rows"

Rob

"Ahmad" wrote in message
om...
Dear all;
I have a small problem with this function, A column has numerical
numbers, I want to count the same numbers, please look to my example
A
1
1
1
2
2
1
3
3
3
2
1
1
3
2
2
The results in this form
1=3 rows
2=3 rows
3=2 rows
thank you