In daily work, it is necessary to count the number of the same names in a list. It is very troublesome to fill in the numbers one by one. So how can Excel quickly count the number of the same names? Below I will share the operation process of counting the number of the same names in Excel. Friends in need should not miss it.

​ ​ Take the sample table below as a reference to count the number of times a name appears.

Just one function is enough. We first count the number of Zhang San’s names. In the cell to be counted, enter the function =COUNTIF and then the left bracket, select the statistical range, enter a comma, and then click to find the object. Click here on Zhang San’s cell. format, and finally enter the closing bracket. The final function is =COUNTIF(A1:B8,C2).

​ ​Select the statistical range just now and press F4 to lock it, which means changing the address to an absolute address.

Finally, press Enter and double-click to fill in, and all name times will be counted.

The above is the operation process of counting the number of the same names in Excel explained by the editor. Let’s learn it together. I believe it can help some new users.