Look in the help index for COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"neerav" wrote in message
...

Hi everibody
In column 1 are cells with different values (some cells have 10, other
have
100 other have 500 etc); How can excel say "there are X cells with value
10,
Y cells with value 100, Z cells with value 500 etc."?
Thanks a lot