How to count the number of identical items in excel

How to count the number of the same items in excel: first select the cells that need to be counted and enter the statistical function; then enter the range that needs to be counted in the brackets, then enter the items that need to be counted; finally set it parameters and press the Enter key.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to count the number of identical items in excel:

1. Open our table file with excel, as shown in the figure:

2. After opening the table, we select the cells for which statistical results need to be calculated, as shown in the figure:

3. In the selected cells Enter our statistical function in the grid, as shown in the figure:

#4. After entering the function, we enter the range that needs statistics in the brackets, as shown in the figure. :

5. After entering the statistical range, then enter the items that need to be counted, as shown in the figure:

6. After setting the parameters of the function, press the Enter key to get the statistical results, as shown in the figure:

7. We will calculate the The function is quoted in all the tables below, so that all statistical results are displayed, as shown in the figure:

##Related learning recommendations:

excel tutorial

The above is the detailed content of How to count the number of identical items in excel. For more information, please follow other related articles on the PHP Chinese website!