SUM

• The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges.
• For example:
• =SUM(F2:F10)

Syntax

SUM(number1,[number2],...)

Argument name	Description
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.
number2-255    (Optional)	This is the second number you want to add. You can specify up to 255 numbers in this way.

Using the AutoSum WIzard

• The easiest way to add a SUM formula to your worksheet is to use the AutoSum Wizard.
• Select an empty cell directly above or below the range that you want to sum, and on the Home or Formula tabs on the Ribbon, press AutoSum > Sum.

AutoSum vertically

• Click on Auto Sum.

• Press Enter.

AutoSum horizontally

• Click on Auto Sum.

• Press Enter.