calculated the quantity of numbers

[Stathis]

Hello

I have a table with many numbers and i want to calculate how many times apears each number.Do you have idea how can i do it?

[martindwilson]

use countif
=countif(a1:h100,12) will count how many times 12 appears in that grid

[Stathis]

Thank you
And my new question is how can i calculate all the numbers (about 500) without type every time the formula?

Sorry i have many years to use excel!

[Stathis]

Solved!

Thank you