How to Do a Cumulative Total on Excel

1. Open the Excel 2010 file in which you want to create a cumulative total.
2. Enter, or move, the numbers you are going to sum into a single column. Ensure that this column has an empty column to the right of it.
3. Select the cell at the top of the empty column to the right of the values. Place an equal sign (=) into the cell to start a formula, then click on the cell at the top of the column with the values to place that cell reference into the formula. Press 'Enter' to complete the formula, and the cell will display the exact same value as the top cell of the original columns.
4. Click the cell directly below the cell where you entered the formula. Press the '=' button to start a new formula. Click the cell at the top of this column to place its coordinates into the formula. Then press the plus sign ( ) sign and click the cell to the left of the cell you are entering a formula in. Press 'Enter' to complete the formula.
5. Move your mouse to the bottom-right corner of the cell you just placed your formula in. When your mouse changes to a plus sign, click and hold the mouse button. Drag your mouse down the column to the last cell where you want to create the cumulative total. Release the mouse button, and the entire column will change to show the cumulative sum for the first column.