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

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

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

On Wed, 2 Mar 2005 16:33:02 -0800, "Chuck-Baby"
wrote:

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

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

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

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

Vaya con Dios,
Chuck, CABGx3


"Chuck-Baby" wrote in message
...
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