Use the SUM function to total numeric values in a column or row. To calculate the total of a series of numeric values in a row or column, you do not have to enter all those values manually into a formula. Instead you can use a predefined formula that uses the SUM function. On a worksheet, click a cell below or to the right of the numeric values that you want to total. On the Home tab, in the Editing group, click AutoSum . Tip: AutoSum is also available on the Formulas tab, in the Function Library group. Press ENTER to display the SUM function result in the selected cell.