Cell Reference

  • Thread starter Thread starter onebodaciousbabe03
  • Start date Start date
O

onebodaciousbabe03

How do I reference the total of a formula on sheet 1 to sheet 2? I hope that
makes sense. Thank you in advance.
 
If total is in cell H1 of Sheet1 then use this in the cell in Sheet2 you want
the total
=Sheet1!H1

If you want to sum the cells on Sheet1 in a cell in Sheet2 then use
=SUM(Sheet1!A1:A10)
 
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

Referring to cells on other sheets using formula 3
How do I create formulas between worksheets? 5
Summing up various Worksheets to one Summary sheet using variables 1
Duplicate "Drag" feature 2
Complex formula help , please. 13
Fill formula down for cells 74 rows apart 3
list and hyperlink 5
Compound Reference 2

Back
Top