Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about how to use Excel summation formula. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Excel is a kind of table making tool which is commonly used in our daily life. It is widely used and can be seen in various industries. For example: make excel course schedule, student score sheet, employee payroll and so on. In fact, excel can not only make tables, it can also provide a lot of functions, can be used to operate on the data in the table (such as addition, subtraction, multiplication and division, etc.). Today, I mainly share some tips on the use of excel summation formula. I hope it will be helpful to you!

1. Quick summation: shortcut key [ALT+=] Quick summation

Select the entire area (B2:G14) and click the shortcut key [ALT+=]

II. Total summation formula including subtotal lines

As shown in the following figure, it is required to set a cumulative summation formula in the cell, which is equal to the sum of the subtotals.

B12=SUM (B2:B11) / 2

Third, the sum of interlaced columns

Intercolumn summation, as shown in the following figure, in the comparison between the plan and the actual table, to calculate the annual plan and actual completion, you can directly use the sumif summation.

The cell formula of F3 is: = SUMIF ($Baud2VERVIED EFLING2, FLINGLING B3VOLING E3)

IV. Summation of merged cells

As shown in the following figure, the category of column An is required to be summed in column D.

D3=SUM (C3:C10)-SUM (D4:D10)

Note: formula input method, select D3:D10, enter the formula in the edit bar and press Ctrl+Enter to complete the input.

5. Summation of numbers with text

The summation of numbers containing text type can not get the correct result with sum, but can be summed with Sumproduct function. As shown in the following figure, the result obtained by Sum summation is obviously wrong.

Ignore the summation of error values

As shown in the following figure, if an area contains an error value, the result will also show an error when summing with sum. If you want to ignore the summation of error values, you can use the sumif function to solve it.

= SUMIF (G2:C12, "

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.