Three sheets total!

[rcoco]

Hi all,
it's been long since I used excel but here again I have to use it. I
need some help.
I have these three sheets that have a total each, and I want to get
the total of the three on the fourth sheet. how can I do this?
Thanks

 

[Guest]

The 'works in all cases' solution:
='Sheet1'!X1 + 'Sheet2'!Y14 + 'Sheet3'!R92

You can get Excel to do the work for you: select the cell where you want the
total of all 3 to appear, type an = symbol to start the formula, choose the
first sheet and cell then type + and choose 2nd sheet and cell, type another
+ and then choose the last sheet and cell and then press [Enter] to complete
the formula.

Special case where the values to be added are all in the same cell on each
sheet AND all sheets are contiguous (one after the other) without any others
in the group:
=SUM('First Sheet Name:Last Sheet Name'!B4)

Again, you can get Excel to do part of the work: select the cell for the
formula, type in
=SUM(
then select 1st sheet in the group, hold down the [Shift] key and select the
last sheet in the group and then click the cell to be used, press [Enter] to
complete the formula.

 

[Guest]

There are a couple ways, type = then click the first total, if adding press +
then go click the next. Another method if they move around is to name them
and then just type the name on the fourth sheet such as =Total1

 

[rcoco]

Thanks guys it's worked properly.

 

[Guest]

=SUM(Sheet1:Sheet3!A10)