What is the function of function sum?

The function of function sum is to return the sum of numbers, logical values ​​and text expressions of numbers in a certain cell range. The SUM function is a mathematical and trigonometric function that adds values; its syntax is "SUM(num1,[num2],...)".

The SUM function refers to returning the sum of numbers, logical values ​​and text expressions of numbers in a certain cell range. If the parameter contains an incorrect value or is text that cannot be converted to a number, an error will result.

The SUM function is a mathematical and trigonometric function that adds values. You can add individual values, cell references, or ranges, or a combination of all three.

(1)Syntax: SUM(num1,[num2],...)

num1 (required parameter) The first number to be added. The number can be a number, or a cell reference like A1 or a cell range like A2:A8 in Excel.

num2, this is the second number to be added.

(2) Description

1. Text expressions of logical values ​​and numbers will be calculated;

2. If the parameter is an array or reference , only the numbers within will be calculated. Blank cells, logical values, and text in arrays or references will be ignored;

3. If there are wrong values ​​in the parameters or text that cannot be converted into numbers, an error will occur.

Example:

(1)SUM(3, 2) is equal to 5;

(2)SUM("3", 2, TRUE ) is equal to 6 because the text value is converted to a number and the logical value "TRUE" is converted to the number 1.

Different from the previous example, if A1 contains "3" and B1 contains TRUE, then: SUM(A1, B1, 2) is equal to 2, because references to non-numeric values ​​cannot be converted to numeric values.

If cells A2:E2 contain 5, 15, 30, 40 and 50, then: SUM(A2:C2) is equal to 50; SUM(B2:E2, 15) is equal to 155.

(3) Use SUM to calculate the balance

As long as the formula is entered in D3, the following format can be copied from the cell of D3:

The same applies to other data operations

Recommended tutorial: "excel tutorial"

The above is the detailed content of What is the function of function sum?. For more information, please follow other related articles on the PHP Chinese website!