Manual Summing. Click an empty cell underneath your column of numbers. Enter the following formula: =SUM(. Click the first cell you want to sum and drag to the last cell you want to sum. For example, if your data reside in cells C2 through C9, click cell C2 and drag to C9. Excel will display the cell range with a colon.