G Genaveve Dec 3, 2003 #1 What is the formula used in order to calculate totals from 2 previous sheets and place into the last column in the last sheet?
What is the formula used in order to calculate totals from 2 previous sheets and place into the last column in the last sheet?
J Jim Dec 3, 2003 #2 =SUM(Sheet1:Sheet2!A200) where A200 on each sheet holds the totals. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays Genaveve said: What is the formula used in order to calculate totals from 2 previous sheets and place into the last column in the last sheet? ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
=SUM(Sheet1:Sheet2!A200) where A200 on each sheet holds the totals. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays Genaveve said: What is the formula used in order to calculate totals from 2 previous sheets and place into the last column in the last sheet? ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
