Excell Spreadsheet Help

[Fencer51]

Anyone know how to get a spread sheet to total numbers from different tabs onto one sheet?

Yeah I am a noob.

[Marauding Conan]

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.

[oakranger]

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.

[Mustaine]

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.

[Getback]

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

[Newman5]

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.

[Forker]

Here's a very simple version (with formulas shown) of diong what you described

[fd ski]

there is also a nifty subtotals function under data tab. It will do lot of stuff you're trying to get working automatically.

[Getback]

Here's a very simple version (with formulas shown) of diong what you described

(Image removed from quote.)(Image removed from quote.)
(Image removed from quote.)(Image removed from quote.)

Oh, I guess mine just wasn't pretty enough. 

[Fencer51]

Thanks Guys!