How to Use Excel Auto Sum
- 1). Open an Excel spreadsheet that contains numerical data to sum, or create a new spreadsheet.
- 2). Click once to move the cursor to a cell directly below or to the right of a series of numbers in one column or row. For example, if the data you want to add are in cells A1 through A10, place the cursor in cell A11. If they're in cells A1 through G1, place the cursor in H1.
- 3). Click the "AutoSum" button, which is in the Editing group, at the right of the Home tab. Clicking the button inserts the formula to add all of the values immediately above or to the left of the selected cell: A dashed outline appears to let you adjust or confirm the selection.
- 4). Press "Enter" to confirm or use the mouse to move the selection area, and then press "Enter."
Source...