The SUM function adds individual values, cell references, or ranges or a mix of all three. For more info, see SUM function.
=SUM(number1,[number2],...)
-
number1 (Required) 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. Example: =SUM(A2:A10) Adds the values in cells A2:10.
-
number2-255 (Optional) Additional numbers, cell references, or ranges to add, up to 255 numbers. Example: =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Tip: For a quick sum, see Use AutoSum.
The SUM function adds individual values, cell references, or ranges or a mix of all three. For more info, see SUM function.
=SUM(number1,[number2],...)
-
number1 (Required) 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. Example: =SUM(A2:A10) Adds the values in cells A2:10.
-
number2-255 (Optional) Additional numbers, cell references, or ranges to add, up to 255 numbers. Example: =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Tip: For a quick sum, see Use AutoSum.
