How to use sum formula

Functions are defined in Microsoft Excel as:

Functions are pre-written formulas that can perform operations on one or more values, and Returns one or more values. Functions can simplify and shorten formulas in your worksheet, especially when you use formulas to perform long or complex calculations.

The SUM function is applied as follows in Microsoft Excel.

Explanation

SUM will be specified as a parameter (a parameter in Microsoft Excel refers to: providing information for an operation, event, method, property, function, or procedure value.) are added together.

Each parameter can be a range ("range" in Microsoft Excel refers to: two or more cells on the worksheet. The cells in the range can be adjacent or not.), Cell reference ("cell reference" in Microsoft Excel refers to: the set of coordinates used to represent the location of a cell on the worksheet.

For example, displayed at the intersection of column B and row 3 cell, which is referenced as "B3".), array (an array in Microsoft Excel is used to create a single formula that produces multiple results or operates on a set of parameters arranged in rows and columns.

Array ranges share a formula; an array constant is a set of constants used as parameters.), constant ("constant" in Microsoft Excel refers to: a value that is not calculated. For example, the number 210 and text "Quarterly Earnings" are constants.

Expressions or values ​​calculated from expressions are not constants.), formulas ("formula" in Microsoft Excel refers to: a series of values ​​in a cell, A combination of cell references, names, or operators that produces a new value. Formulas always begin with an equal sign (=).) or the result of another function.

For example, SUM(A1:A5) adds all the numbers in cells A1 to A5. Another example, SUM(A1, A3, A5) adds the numbers in cells A1, A3, and A5. add.

Syntax

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

SUM function syntax has the following parameters (parameters: values ​​that provide information for an operation, event, method, property, function, or procedure.):

number1 Required. The first numeric argument to be added.

number2,,... Optional. 2 to 255 numeric arguments to be added.

Explanation

If the parameter is an array or reference, only the numbers in it are calculated. Blank cells, logical values, or text in arrays or references are ignored. If any argument has an incorrect value or is text that cannot be converted to a number, Excel will display an error.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column to learn!

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!