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

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

Luke M

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.
 

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

How do I link a cell in a workbook? 1
I need to scan a column 6
How to hide a control on a different tab [page] of a form? 5
grab cell text from multi-tab workbook, show text in another workb 0
how to pull data from a specific cell on each tab as I add tabs 2
Pulling data from one tab to another & matching it 0
Indirect Hyperlink from a graphic to a calculated cell or range 5
Sheet won't reference a named cell 4

Top