Home  >  Article  >  Topics  >  Is excel's summation function sun?

Is excel's summation function sun?

烟雨青岚
烟雨青岚Original
2020-07-14 16:02:537399browse

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],...)".

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. 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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn