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

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?

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mitch Harrison" wrote:

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?