Using SUM Function 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