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

For example:

  • =SUM(A2:A10)

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



Source: Microsoft