EXCEL table counts the number of employees dining?

This is an easy problem to solve. Use the PivotTable method.

See the figure for operation.

This is the result.

Operation started:

Open your form.

Select the range that contains the data to count. The red box on the left in the picture.

3. Click Insert in the menu bar.

4. Insert the PivotTable report.

5. We have selected the data area, so it is automatically selected here.

6. Select the data statistics area, click F 1, drag to G 12, and release the mouse.

7. Click OK and see the figure below. Check these three labels first.

8. In the figure, the three labels move as shown in the figure. The results came out. Very interesting. Just try it.