How to use sum formula?

How to use the sum formula?

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.

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