(Figure 2)

counting function

County (district)

Function: Count the non-empty cells in the selected area Case: Calculate the attendance days of employees in Mu Nianci.

Step: Enter COUNTA formula, select the attendance result area from September/kloc-0 to September 6 in Mu Nianci, and confirm.

(Figure 3)

COUNTblank function

COUNTblank (area)

Function: Count the empty cells in the selected area.

Case: Calculate the absence days of employee Mu Nianci.

Step: Enter the COUNTblank formula, select the attendance result area from September/kloc-0 to September 6 in Mu Nianci, and confirm.

(Figure 4)

Counting function

Count (Region)

Function: Count the numerical cells in the selected area Case: Calculate the number of employees with commission.

Step: Enter the calculation formula, select the commission column in the area and confirm.

(Figure 5)

COUNTIF function

COUNTIF (region, condition)

Function: Statistics of qualified cells in the selected area Case: Statistics of the number of employees with sales above 40,000.

Step: Enter the COUNTIF formula, enter the condition that the sales column for regional selection is greater than 40000, and confirm.