Counting instances in a list

  • Thread starter Thread starter young1974
  • Start date Start date
Y

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
 
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.
 
Back
Top