function adds values. You can add individual values, cell references or ranges or a mix of all three.
=SUM(A2:A10)Adds the values in cells A2:10.
=SUM(A2:A10, C2:C10)Adds the values in cells A2:10, as well as cells C2:C10.
The first number you want to add. The number can be like 4, a cell reference like B6, or a cell range like B2:B8.
This is the second number you want to add. You can specify up to 255 numbers in this way.
This section will discuss some best practices for working with the SUM function. Much of this can be applied to working with other functions as well.