What does function sum mean?

The function sum means to return the sum of numbers, logical values, and text expressions of numbers in a certain cell range. If there are incorrect values ​​in the parameters or text that cannot be converted into numbers, an error will occur. .

The function sum means:

The SUM function refers to returning the number in a certain cell range. The sum of logical values ​​and textual expressions of numbers. 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(number1,[number2],...)

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

number2, 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 in it will be calculated. 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.

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