How to Calculate Ranges in Excel 2007

1. Open Excel. Click the 'Office' button. Select 'Open' from the menu.
2. Highlight the file you want to open. Click the 'Open' button.
3. Highlight the cells that you want to put in the range. Click in the 'Name Box' to the left of the 'Formula Bar.' Type a name for the range. Repeat this step until you have created all the needed ranges.
4. Click in the cell where you want to perform the calculations. Hold the 'Shift' key and tap the 'F3' key on the keyboard. Select the type of calculation from the 'Select a function' pane in the 'Insert Function' window.
5. Type the name of the range in the 'Number1' field of the 'Function Arguments' window. Type the name of the next range for this calculation in the 'Number2' field (This is optional if the 'Number1' field range contains more than one cell). Click the 'OK' button.