The SUM function adds up all the numbers in a specified range of cells.

The AVERAGE function calculates the arithmetic mean of its arguments, which can be numbers, names, arrays, or references that contain numbers.