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:
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!