What is the summation function?

The summation function is the SUM function; the SUM function returns the sum of numbers, logical values, and text expressions of numbers in a certain cell range; if there is an error value in the parameter or it is text that cannot be converted into a number, will result in an error.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, DELL G3 computer.

Excel is a very important software in office automation, and Excel functions are built-in functions in Excel. Parameters in functions are not just constants, formulas or functions, but can also be arrays, cell references, etc.

The summation function in Excel is the SUM function. The SUM function returns the sum of numbers, logical values, and text expressions of numbers in a range of cells. If the parameter contains an incorrect value or is text that cannot be converted to a number, an error will result.

sum function syntax is:

SUM(number1,[number2],...)

Parameters:

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.

Recommended: "Excel Tutorial"

sum function usage instructions:

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. 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 What is the summation function?. For more information, please follow other related articles on the PHP Chinese website!