Is excel's summation function sun?

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!