How the Excel Sum function uses the

The SUM function is the SUM function. It is one of the most commonly used functions in Excel functions, and the SUM function appears in the two categories of mathematical functions, all functions, and the default "common functions".

The SUM function has the syntax form: sum (number1,number2, ...)

Considerations for the SUM function:

1, the function of the syntax of Number1,number2 and other parameters, up to 30;

2, the function of the syntax of Number1,number2 and other parameters, can be either a number (example 1), or a logical value (example 3), or an expression (example 3), a cell name, a collection of contiguous cells (example 2), or a range of cells name. And the categories listed above will be counted;

3, if number1, such as cell name, contiguous cell collection, cell range name, only the numerical value and function formula of the numerical results, do not calculate the logical value, table text expression (example 4);

Sum Function Example:

Sample Table	A
1	3
2	1
3	1+2
4	(1+2=3)
5	3d

A is the column number in the table above, and the left 1-5 is the line number.

If you enter the result of the following formula in cell A6:

The results of Example 1, =sum (1,2,3) were 6, and the number of 1, 2 and 33 digits was calculated.

The result of Example 2, =sum (A1:A2) is 4, and the sum of A1 to A2 cell is computed.

Example 3, =sum ((1+2=3), (1+2), (A1:A2) The result is 8, because the result of the (1+2=3) expression is true, the result of the 1,1+2 expression in the computer is computed, and A1 to A2 cell and 4 is computed, so the final result is 8;

The result of example 4, =sum (A1:A5) is 4, no literal expression (1+2), logical expression (1+2=3) in the reference cell is evaluated, and no characters are computed;

The above is a simple example of the SUM function, I hope that the triple-Ehoy to provide these examples of information for everyone to help Oh!

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join