Microsoft Excel

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

Guest

Can I create a summary worksheet in a workbook that contains totals from each
worksheet in that workbook.
 
Yes,
This formula in any cell in Sheet1 will return the value in Cell D1 of Sheet2
=Sheet2!D1

Likewise, this one will return the value in cell G7 of Sheet3, etc etc
=Sheet3!G7

hth
Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Excel Count If Formula Question 1
Excel 2007 - Linking workbooks 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Find & Replace a link to another worksheet in the same workbook 1
Consolidate Multiple Workbooks - Excel 2007 1
changing worksheet reference name when copying down cells 5
summary values across worksheets within the same workbook 2

Back
Top