How to quickly sum up batches in excel How to quickly sum up batches in excel Calculation method

Fast Batch Sum Tips Many users are looking for ways to sum data in batches quickly and efficiently. This article will introduce two easy methods: the menu bar auto-sum button and the shortcut key. By knowing these tips, you can easily sum up large amounts of data, thereby increasing your productivity. Continue reading this article and you will learn: How to use the automatic sum button in the menu bar Convenient batch sum shortcut keys Examples of using these methods to solve actual work scenarios

Method 1. Menu bar Automatic sum button

Move the mouse to select the cell area in the table that needs to be automatically summed. Press the CTRL key to select multiple areas that require summing at the same time. Click the Formula tab on the menu bar and click the AutoSum button in the upper left corner.

The result of automatic summation is displayed below the data area. Move the mouse to the total cell, and the summary formula =SUM ( F2:F9).

Method 2, shortcut key summing

In the EXCEL table, about SUM There is a set of very useful shortcut keys for function summation, which is ALT+=.

Select the summing area in the table, and you can also select multiple summing areas at one time. Press the shortcut key combination to display the summation result in the cell, and the summation formula can be viewed in the edit bar above.

Method 3, use super table to automatically sum

Select the entire table area, Click Insert-Table on the ribbon.

After the ordinary table is converted into a super table, a new table design tab is added to the ribbon, click on the summary row in the table style option, check it, below Summary row added.

Click the summary cell below the quantity column, a list will pop up, select sum, and the summation results will be automatically displayed in the cell.

Click the arrow on the right side of the table style to pop up the list, click Clear below.

The style of the table is cleared, but the automatic summary rows will still be retained.

The above is the detailed content of How to quickly sum up batches in excel How to quickly sum up batches in excel Calculation method. For more information, please follow other related articles on the PHP Chinese website!