How to Enter Sum Formulas into Multiple Cells in Microsoft Excel 2003

Using the advanced features of Excel spreadsheet software allow for the easy manipulation of formulas from cell to cell inside of the spreadsheet. Developers have spent a great deal of time working on and modifying these programs to offer a more user-friendly interface. One of the more commonly used formulas in this program is the sum formula, which allows you to sum the span of data contained in cells that you specify. This formula is for adding the numbers of different groups of cells together to create the final sum of the data and placing it into a specified cell.

Things You'll Need

• Microsoft Excel 2003
• Spreadsheet with cell data

Instructions

1. Select and activate an empty cell. Do this by left-clicking on that cell; you will also need at least two cells that contain data to be summed.

2. Enter the sum formula perquisites into the cell you have selected. Your first part of the formula should read as: =Sum(.

3. Highlight cells you wish to include in the sum formula. These cells will appear in a blue formula box.

4. After highlighting the desired cells to be included in the sum formula, press the enter button to implement this new formula.

Tips & Warnings

• If you select a cell that already contains a formula you will overwrite it.