Excel - How do I make a cell calculate from another page or tab

  • Thread starter Thread starter Mitch Harrison
  • Start date Start date
M

Mitch Harrison

I have a Workbook "IFTA FUEL TAX FORM" with several named tabs in it. I am
trying to make the tabs calculate between each other. For instance Page1, &
Page2, tabs will calculate the results from the Mileage and Fuel tab. Page 3
will calculate the "totals" cell from Page1 & Page 2 tabs. What formula
language do I use to reference between the tabs?
 
Sheet names are written before cell reference, followed by an exclamation
mark. If there is a space in sheet name, inclose in single quotes.
Examples:
=SUM('My Sheet'!A2:A100)
=LOOKUP(A2,Sheet2!B2:C100)

Note also that if you type "=" into a cell, you can then navigate to another
sheet tab, and the formula will write the reference for you.
 
Back
Top