How to Add Cells Across Multiple Spreadsheets
- 1). Open the spreadsheet that you want to insert a calculation in and the spreadsheet containing the value that you want to reference.
- 2). Click the cell that will contain the calculation and type the equal "=" sign.
- 3). Change the window to the spreadsheet containing the value that you want to reference. In Excel 2007, this is done by clicking the "View" tab and the "Switch Windows" button. In previous versions of Excel, click "Window" then click the spreadsheet that you want to change to.
- 4). Click the cell that you want to reference. The formula updates on the top of the window.
- 5). Type the remainder of the mathematical operation. For example, if you are adding a specific number, type the plus sign "+" followed by the number. Press "Enter" when you are finished typing the operation. To add the value in a cell from one spreadsheet to the value of a cell in another spreadsheet, type the plus sign, then change back to the previous window. Click the cell that you wish to add and press "Enter" to complete the formula.
Source...