How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table

The company holds a general meeting, and branches from all over the country actively participate. It is necessary to count and collect the number of participants in each regional branch. However, the data in the Excel table is complicated. How to efficiently count the number of participants in each regional branch? PHP editor Banana today brought the method of counting the number of participants in various regional branches using Excel table data. Let’s take a look at the specific operation with the editor!

1. Create a new Excel document, open it and add test data in the table, as shown in the figure.

2. After adding 10,000 test data, enter the calculation formula =SUM((LEFT($D$6:$D$13,2)="Guangdong")* in cell H5 $E$6:$E$13), left means intercepting the string starting from the left, and sum means summing. The formula means that when the two texts intercepted starting from the left are equal to the value in the condition, the data will be summed.

3. After completing the formula input, press the shortcut key to obtain the calculation result. If you use the enter key here, you will not be able to obtain the calculation result. The details are as follows.

4. Therefore, you need to use the shortcut key shift ctrl enter to obtain the result. The result is as shown in the figure.

5. When counting participants from branches in other two provinces, we only need to copy the formula in cell H5 and change [Guangdong] in the condition to [Anhui] , [Sichuan], just use the shortcut key shift ctrl enter to get the calculation results.

The above is the detailed content of How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table. For more information, please follow other related articles on the PHP Chinese website!