SUM function

The SUM function, one of the math and trig functions, adds values.You can add individuals values, cell references or ranges or a mix of all three

For example:

=SUM(A2:A10)
=SUM(A2:A10, C2:C10)

Select the blank cell in the row below the cells that you want to sum, cell A5 in this example.




Click the AutoSum command on the Ribbon's Hone tab,
or use the keyboard shortcut: Alt +