Math and Trignometric - SUM Function

Description

The SUM function adds values.

SUM (number1, [number2]...)

Argument	Description	Required/Optional
number1	The first number you want to add. The number can be a value, a cell reference, or a cell range.	Required
number2, …	You can specify up to 255 additional numbers.	Optional

Numbers and Dates are always counted as numeric values by the SUM function.
However, Text representations and Logical values are handled differently, depending on whether they are values stored in the cells of the worksheet, or they are supplied directly to the function. See the table given below for the details−

	Value Within a Range of Cells	Value Supplied Directly to Function
Numbers	Included	Included
Dates	Included	Included
Logical Values	Ignored	Included (True = 1; False = 0)
Text Representations of Numbers & Dates	Ignored	Included
Other Text	Ignored	Included
Errors	Error	Error

If any of the number arguments that are supplied directly to the SUM function cannot be interpreted as numeric values, SUM returns #VALUE! Error.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_math_trigonometric_functions.htm