1. Open the excel table and directly select the cell range to be filtered and counted.

2. Then click the Insert option in the toolbar above the table and select PivotTable.

3. Drag the data column into the filter box and drag the data column into the value box at the same time.

4. Click the Data drop-down box, click the value to filter, and then click OK.

5. You can filter the cells and calculate the statistics of the filtered values.