To sum a range of cells, use the SUM function (see second image on this page). You can also use the SUM function in Excel to sum an entire column.


Note: =SUM(5:5) sums all values in the 5th row. To create awesome SUM formulas, combine the SUM function with other Excel functions.