SUM-thing Important: The SUM Function (beginner)

SUM is probably the most commonly used function in Excel or any spreadsheet program. It provides a simple way of adding a set of numbers, especially when those numbers are located in adjacent cells (a row or column of numbers, for example). The SUM function uses the following syntax:

SUM(values)

The values placeholder can be a list of values, a list of cell references, or a range of cells. Use a range reference if the values are grouped together in a row or column. Use a list of values if they are not adjacent; these values should be separated by commas. Here are some examples:

SUM(C5,C8,D10) adds the sum of these three cells
SUM(C5:C10) adds the sum of the range C5 through C10

Remember to begin all formulas in Excel by typing an equals sign. To enter the above function as a formula in Excel, type =SUM(C5:5C10).

Indicating a column to be added in the SUM function.

Indicating specific cells to be added in the SUM function.