share/ link info between sheets

  • Thread starter Thread starter thapelo1
  • Start date Start date
T

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?
 
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)
 
Back
Top