Xiao Yang Sum function with an example to explain the detailed usage of SUM

Welcome to Office College, xiaoyang visit here waiting for you!

Today, we continue to learn together with you in all commonly used Excel spreadsheet formulas (functions) of the detailed usage and master the formula, many of our work will greatly improve the efficiency, we must learn yo, there do not understand can go to the Office College Questions (ask.officexy.com) here to ask Oh, we have progress, I will be pleased got:)

This lecture, to learn about our SUM

Purpose: Returns a range of cells and all the figures.

Syntax

SUM (number1, number2, ...)
Number1, number2, ... the 1-30 need to sum parameters.

To the parameter list by typing the numbers, logical values and text representations of numbers will be calculated, see the following sample I and sample II.
If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text, or an error value will be ignored. See the following example three.
If the parameter value or an error can not be converted into digital text, will result in an error.
Help

1, row or column sum

The most common salary scale (above), for example, characterized by the need of the row or column sum of a number of cells.
For example, find that the unit in May 2001 the total amount of wages actually paid, you can enter the formula H13: = SUM (H3: H12)

2, the regional sum

Regional sum of a worksheet used in all the data requirements in total. At this point you can make the cell pointer stored results remain in the cell, and then enter the formula bar in Excel "= SUM ()", the middle click with the mouse in parentheses, and finally dragged off the sum of all cells need. If these cells are not continuous, you can Ctrl + drag over them, respectively. The cells that need less, you can select them one by holding down Ctrl key, and then referenced in the formula by hand before the cell with a negative number. Of course, you can also use the formula option board to complete the job, but for the SUM function is still to the faster hand. For example, H13 formula can be written as:

= SUM (D3: D12, F3: F12)-SUM (G3: G12)

3, note

SUM function parameters, he incurs the cell or range of the sum can not exceed 30. In other words, SUM function appears in parentheses separator (comma) no more than 29, or Excel will prompt too many parameters. Sum of a constant need to be involved, the available "= SUM (range of cells, constant)" in the form of direct reference, generally do not store the constant absolute reference cell.

Example 1
SUM (3, 2) equal to 5

Example 2
SUM ("3", 2, TRUE) is equal to 6, because the text is converted into digital values, while the logical value "TRUE" is converted into a digital one.