How do I make a 5th sheet to total cells from previous sheets in .

[Chuck-Baby]

I have four sheets of information from different groups. I want to build a
fifth sheet to compile the previous four sheets. I do not know how to write
the formula to work between sheets. Can someone give me some assistance?

CB

 

[Gord Dibben]

CB

Maybe as simple as a 3D reference.

On Sheet5 enter =SUM(Sheet1:Sheet4!A10)

Which will give you a total of all the A10's

OR maybe more complex?

Post back with more details if the above is not sufficient.


Gord Dibben Excel MVP

 

[CLR]

To use Sheet Names..........

=SUM(MyFirstSheet!A1,MySecondSheet!A1,MyThirdSheet!A1, MyfourthSheet!A1)

Then copy it down and over............

Vaya con Dios,
Chuck, CABGx3