Excel worksheet total up to show in another worksheet

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

Guest

I have two worksheets. The first is the nice printable page. On the second
page I just total up my receipts. How do I get those totals to show on
Worksheet 1 in a cell called Total?
 
Hi
Just say your totals to be added are in A2:A120 in Sheet 1 then
=SUM(Sheet1!A2:A120)

hope this help
 
Back
Top