How to form a formula in diff. sphreadsheets

[Guest]

I have 5 sphreadsheets, of the #5 or last spreadsheet this is a total value's
come from Spreadsheet 1,2,3 and 4. I mean I dont want to fill up manually in
spreadsheet #5. What I want is when I fill up sphreadsheet 1 or 2, 3 , 4, the
sphreadshhet #5 will be automatically change the value. How

Example:
Sp # 1 SP#2 SP #3 Sp #4 Sp#5
Tank 1 Tank 2 Tank 3 Tank 4 Total

230 250 200 400 ??

Thanks and regards.

 

[Guest]

Sp # 1 SP#2 SP #3 Sp #4 Sp#5
A Tank 1 Tank 2 Tank 3 Tank 4 Total
B
C 230 250 200 400 ??

in Sheet5 C1 =Sheet1!C1+Sheet2!C1+Sheet3!C1+Sheet4!C1++Sheet5!C1

pls do rate

 

[Guest]

Mike

Try this on Sp#5
in cell D1 for example assuming that your sheets are called Sheet1,
Sheet2,..........

=SUM(Sheet1:Sheet4!D1)

 

[Tim Lindsley]

Two options that I can think of.

First, you can use Excel's "consolidate" option. Just go to data-->
consolidate. Then select the area you wish to sum on Sheet1 and click
"Add." The reference should show up in the "All references" box.
Select the data in Sheet2 and click "Add" and so on. When all four
references are in the "All references" box, click on Sheet5 to select
where you want the consolidated data to appear and click OK. (Make
sure the reference in Sheet5 is not showing in the reference box.) If
you want the data linked, check the box that says "create links to
source data." This option can be cumbersome and confusing, though.
Here's a link: http://support.microsoft.com/kb/214270.

The second option, the one I prefer, is to create 3-D references. All
you do is select the cell in Sheet5 that will contain the first total
value (A1 in this example) and type: =SUM(Sheet1:Sheet4!A1). This
formula sums all of the values in A1 in the other four sheets. Its
equivalent is =Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1. Use the fill
handle to drag the formula where you want them on the sheet.
Alternatively, you can select the cell in Sheet5 and type "=SUM(."
Then you can select Sheet1, hold down the shift key and select Sheet4,
release the Shift key and select A1 in Sheet4. This accomplishes the
same thing. Here's a link to 3-D references:
http://office.microsoft.com/en-us/excel/HP052019651033.aspx?pid=CH010036991033.

Tim

 

[Guest]

thanks a lot it works.
I'm not sure where I can rate the question.

 

[Guest]

Thanks a lot it works.

I try to find out how to rate the answer