Aces High Bulletin Board
General Forums => The O' Club => Topic started by: Fencer51 on May 16, 2009, 05:16:11 PM
-
Anyone know how to get a spread sheet to total numbers from different tabs onto one sheet?
Yeah I am a noob.
-
Anyone know how to get a spread sheet to total numbers from different tabs onto one sheet?
Yeah I am a noob.
Use the command for equation (it looks like a greek capital e), this will open a box for equation, simply type + and click on the total of the other tab, it will automatically include that box on the equation.
-
Anyone know how to get a spread sheet to total numbers from different tabs onto one sheet?
Yeah I am a noob.
Yea, send me what you want and i can show you how.
-
depends on which excel version...
for example in office 07 this would be the function:
=SUM(A1,Sheet2!A1)
when cell A1 on sheet 1 has a number value, and cell A1 on sheet 2 has a number value
in older versions of excel I think it is a bit different, I can't remember honestly.
-
Displayed Formulas, Period 3, etc. are the names I gave the worksheets, Hence the apostrophe. I just merely typed an equal sign and then clicked the cells in the worksheets I wanted. Actually just did this to the first individual and dragged down for the rest.
Bob ='Period 3'!F6+'Period 2'!E6+'Period 1'!D6
Ted ='Period 3'!F7+'Period 2'!E7+'Period 1'!D7
Sue ='Period 3'!F8+'Period 2'!E8+'Period 1'!D8
Juan ='Period 3'!F9+'Period 2'!E9+'Period 1'!D9
Shirley ='Period 3'!F10+'Period 2'!E10+'Period 1'!D10
Sally ='Period 3'!F11+'Period 2'!E11+'Period 1'!D11
Killer ='Period 3'!F12+'Period 2'!E12+'Period 1'!D12
Myman ='Period 3'!F13+'Period 2'!E13+'Period 1'!D13
Total =SUM(E6:E14)
Verify ='Period 3'!F15+'Period 2'!E15+'Period 1'!D15
Same data with formulas hidden
Sales Commissions
Bob $275.00
Ted $495.00
Sue $256.00
Juan $257.00
Shirley $258.00
Sally $300.00
Killer $722.00
Myman $1,755.00
Total $4,318.00
Verify $4,318.00
-
Anyone know how to get a spread sheet to total numbers from different tabs onto one sheet?
Yeah I am a noob.
In the cell you want it to appear, type =sum( then click the first tab that contains your first value, and then the cell with the value, then type + and click the second tab with the second value, and then the cell with the value, then type + and click the third tab with the third value....rinse, repeat. At the end, be sure to put the ) to close the parenthesis. Also, just an FYI, the first, second, or third tabs in my example could theoretically be the on the same tab in your situation. It will work either way.
-
Here's a very simple version (with formulas shown) of diong what you described
(http://i41.photobucket.com/albums/e263/Forker1/ExcelI.jpg)(http://i41.photobucket.com/albums/e263/Forker1/ExcelII.jpg)
(http://i41.photobucket.com/albums/e263/Forker1/ExcelIII.jpg)(http://i41.photobucket.com/albums/e263/Forker1/ExcelIV.jpg)
-
there is also a nifty subtotals function under data tab. It will do lot of stuff you're trying to get working automatically.
-
Here's a very simple version (with formulas shown) of diong what you described
(http://i41.photobucket.com/albums/e263/Forker1/ExcelI.jpg)(http://i41.photobucket.com/albums/e263/Forker1/ExcelII.jpg)
(http://i41.photobucket.com/albums/e263/Forker1/ExcelIII.jpg)(http://i41.photobucket.com/albums/e263/Forker1/ExcelIV.jpg)
Oh, I guess mine just wasn't pretty enough. :lol :lol
-
Thanks Guys!