Counting instances in a list

[young1974]

Hi,

I am not sure if this has been discussed before, but I can not
find anything on the forums.

What I am wanting to do is count the number of instances of a
particular number in a list.

Example Sheet

A1
1 444
2 444
3 444
4 444
5 444
6 555
5 555
6 555
7 555
8 333
9 333

Result I want is at the bottom of the list if possible is :-

A1
10 444 5
11 555 4
12 333 2

Any help would be appreciated, thank

 

[Jotan]

Try the COUNTIF function.

In the cell where you want the result, type
=COUNTIF(A1:A9,"444")

Change the value after the comma accordingly.

Hope this helps.