Addition and the SUM Function

    1100674 VIEW 0 0

Excel uses standard operators for formulas, such as a plus sign for addition (+), All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.

Syntax:  =SUM (number1, [number2], [number3], ...)

Arguments 

  • number1 - The first value to sum.
  • number2 - [optional] The second value to sum.
  • number3 - [optional] The third value to sum.

Formula =A1+A2+A3+A4+A5+A6+A7+A8

Function =SUM(A1:A8)

Multiple arguments must be separated by a comma. For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all the cells in the three arguments.

These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments

 

Download Addition and the SUM Function Excel Addition File.xlsx