What function is sum?

#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(number1,[number2],...)

number1 (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.

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.

For more related tutorials and programming learning courses, please continue to pay attention to the PHP Chinese website!

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