The summation function of excel is not "sun", but "sum". The SUM function refers to: returning the sum of numbers, logical values, and text expressions of numbers in a certain cell range; its syntax is: "SUM(number1,[number2],...)".
The summation function of excel is not sun, but 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 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.
Recommended tutorial: "excel tutorial"
The above is the detailed content of Is excel's summation function sun?. For more information, please follow other related articles on the PHP Chinese website!