Thursday, August 11, 2011

How to Use MS Excel 2007 to Calculate Sum


1. Enter values into a row or column of cells.
2. Navigate to the cell you want the sum to appear. You may pick any cell, even one nowhere near the cells you want to sum.
3. Click the 'AutoSum' button in the Editing Box at the far right of the Home tab. Excel will enter the Sum Function in the active cell, including a range of cells to add.
4. Make certain the cell range is correct (notice the dashed box for a visual representation of the cell range). Press the Enter key to confirm the Sum function.
5. Drag through another range of cells if the range Excel entered is not the range you need summed. In other words, left click into the first cell you want in the equation and move the mouse through the additional cells. Press the Enter key to confirm the function.

Blogger news