How to count the number of the same names in Excel_One function can do it

Want to count the number of cells with the same name in Excel? PHP editor Baicao brings a simple and efficient function today to solve your troubles! This function is not only simple and easy to use, but also provides you with the data you need quickly and accurately, allowing you to easily grasp the data distribution. Come and read the following to learn how to use this function to make your data processing more convenient!

First of all, take the sample table below as a reference. We want to count the number of times a name appears.

We only need one function. We first count the number of Zhang San’s surnames, enter the function =COUNTIF in the cell to be counted, then leave the bracket and select the statistics in the box Range, then enter a comma, then click Find Object, here click Zhang San’s cell, and finally enter the right bracket. The final function is =COUNTIF(A1:B8,C2).

Then 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. All name times will be counted. It is very simple.

The above is the detailed content of How to count the number of the same names in Excel_One function can do it. For more information, please follow other related articles on the PHP Chinese website!