For example, the table data in the figure below calculates the quantity by month.

Please click to enter a picture description.

Select the table with the mouse, as shown in the figure below.

Then, click the Insert tab.

Please click to enter a picture description.

The relevant command pops up below;

Then, on the far left, click PivotTable.

Please click to enter a picture description.

Pop up the operation box for creating pivot table;

According to his actual situation, Bian Xiao clicks "existing worksheet" here, and then chooses the location where to put the pivot table. Click OK.

Please click to enter a picture description.

The right side of the worksheet shows the window for setting up the pivot table. Click Date and drag it to Line.

Please click to enter a picture description.

Please click to enter a picture description.

Click Quantity and drag it to Value.

At this point, the table shown in the following figure will be displayed on the worksheet.

Please click to enter a picture description.

Please click to enter a picture description.

Click on the triangle here, and the filter list will pop up. Place the mouse on the Label Filter and click Between in the pop-up menu on the right.

Please click to enter a picture description.

In the pop-up operation box, enter the start date of the month, for example, February, and enter 2017/2/1; 20 17/2/28

As shown in the figure below,

Please click to enter a picture description.

Click OK, and the February figures will be counted on the table.

Please click to enter a picture description.

And so on, March statistics, April statistics.

Please click to enter a picture description.

Please click to enter a picture description.