Help with a COUNT formula to show total an ID occurs - not a running total

Hello,

I was hoping somebody could help.

I have a list of employees and am looking for a formula that give a total for the number of times they feature in a list. I have a formula that gives the below result:

=COUNTIFS($A$2:A4,A4)

Result:

EF.PNG

I was expecting the count column to show 3 for each row because the data in Cell A2 occurs 3 times.

Any help would be much appreciated.

Thanks.