How to automatically sum by month in excel

How to automatically sum in Excel by month: First create the data that needs to be summed in the table, and click the "Insert" and "Pivot Table" options in the toolbar; then click the "OK" button , drag "Month" into the "Filter" box, drag "Data" into the "Value" box; finally click on the month.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to automatically sum in excel by month:

1. First open the excel table and create the data that needs to be summed in the table. It needs to be calculated according to the month. and operations.

#2. Click the "Insert" "Pivot Table" option in the toolbar.

#3. Click the "OK" button in the pop-up dialog box.

4. Then the settings bar of the Pivot Table will pop up on the right side of the page. Drag "Month" into the "Filter" box and drag "Data" into Value box.

5. Then click the drop-down box to the right of "All" in the table. In the drop-down option, you can select the month to be counted as needed, for example, select March and click Sure.

#6. The sum of all data in March can be displayed on the page.

Related learning recommendations: excel tutorial

The above is the detailed content of How to automatically sum by month in excel. For more information, please follow other related articles on the PHP Chinese website!