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