Use the SUM function

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.

To combine text or other non-numeric values, see Use the CONCAT function.

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.

To combine text or other non-numeric values, see Use the CONCAT function.

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.

To combine text or other non-numeric values, see Use the CONCAT function.

Tip: For a quick sum, see Use AutoSum.