Linking data from other worksheets to formula

[smooveface]

I am trying to do something that I know is very simple, but just doesn'
seem very intuitive with Excel. I have a series of worksheets that hav
data in them over various months. I have a total spreadsheet that
would like to be able to agregrate all of the the data from the othe
worksheets into a summary page. For example, I have utilization number
for each month of the year on the other worksheets and would like t
take the utilization for each month so that I could take data from eac
on the other worksheets and add them together and be represented as on
cell on the total page. Can someone help me with this

 

[Robert Rosenberg]

Are the monthly utlization numbers in the same cell on each worksheet? If
so, do the following (if not, see alternative method below these steps)...

1. Select the cell on the Summary worksheet where you want the total
utilization to go

2. Type the following beginning portion of the total formula: =SUM(

3. Click the first monthly worksheet tab
The name of that worksheet will appear in the total formula

4. Select the cell containing the monthly utilization figure
The cell address will appear in the formula after the worksheet name

5. Hold down the Shift key on the keyboard while you click the last monthly
worksheet tab
Your formula should look something like the following: =SUM(Janec!B5
Note: Jan = the name of my first monthly worksheet and Dec = my last
monthly worksheet

6. Press the Enter key

If the monthly figures are not in the same cell on each worksheet, you can
still add them up using the following technique:

1. Select the cell on the Summary worksheet where you want the total
utilization to go

2. Type the following beginning portion of the total formula: =SUM(

3. Click the first monthly worksheet tab
The name of that worksheet will appear in the total formula

4. Select the cell containing the monthly utilization figure
The cell address will appear in the formula after the worksheet name

5. Type a comma (,), which tells the formula you want to add another
reference to the SUM function

6. Click the next monthly worksheet tab

7. Select the cell containing the monthly utilization figure

8. Type another comma (,)

9. Repeat this process until every utilization figure has been added to the
formula

10. Press Enter

--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com