share/ link info between sheets

[thapelo1]

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?

 

[Gary''s Student]

Say we have a table in Sheet1 from A1 thru D10. In Sheet2 we want the sum of
the first column in Sheet1. Use:

=SUM(Sheet1!A1:A10)

 

[thapelo1 via OfficeKB.com]

Thx Gary it worked like a charm!!

Regards
Thapelo