Excel worksheet total up to show in another worksheet

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?
 
N

nika

Hi
Just say your totals to be added are in A2:A120 in Sheet 1 then
=SUM(Sheet1!A2:A120)

hope this help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referrence a total in a cell on another worksheet 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Is there a way I can add totals in worksheet? 3
Formula not copying over as before 1
Excel workbooks 3
Copy formula from one worksheet to another to get value in 2nd wks 1
totals 4

Top