Linking from several cells of 1 spreadsheet to fewer of another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to link some payroll info. Specifically, I have Sheet 1 with the
employees' totaled regular hours and totaled OT hours, for 2-week time
periods. I want to link the totals of those totals into specific cells in
another spreadsheet (Sheet 2). Help?
 
In whatever specific cell you want on Sheet2, enter:

=SUM(

then use the mouse to select the appropriate range of cells on Sheet1, close
the parenthesis, and hit Enter..
 
Back
Top