1. First select the Excel table and double-click to open it.
2. Then, in this interface, select the cell where you want to count the number of employees.
3. In this interface, enter the formula "=COUNTA(A2:A8)" in the formula column to count the number of employees according to their names. 4. Finally, in this interface, the results of counting the number of employees according to their names are successfully displayed in the cell.