7 Ways to Add Cell Values in Microsoft Excel. Sum Function, Auto Sum Formula, Insert Function

Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. To create awesome SUM formulas, combine the SUM function with other Excel functions.

Whenever you need to sum a single range of cells, whether a column, row or several adjacent columns or rows, you can have Excel AutoSum to automatically make an appropriate SUM formula for you.

Link to the Workbook is below.