- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Is there an Excel formula to get the subtotals from one sheet onto another sheet?
Posted on 10/3/17 at 8:42 am
Posted on 10/3/17 at 8:42 am
I've subtotaled hours of classes taken by social security number on one sheet
then on a different report, I'm manually entering the hours each person took
what kind of formula could I use to grab the subtotals?
TIA
then on a different report, I'm manually entering the hours each person took
what kind of formula could I use to grab the subtotals?
TIA
1
Posted on 10/3/17 at 9:18 am to Paige
You can probably either use vlookup or sumif. I would go with sumif.
Posted on 10/3/17 at 9:50 am to CubsFanBudMan
I tried v lookup but it just grabbed one of the classes instead of the subtotal
Not sure on sum if
Not sure on sum if
Posted on 10/3/17 at 10:11 am to Paige
It's quite easy.
Have both sheets open,
Create a =sum() formula in a cell in the sheet you want to pull the data FROM,
Go to the sheet that you want that subtotal to be shown,
Choose a cell and put your cursor in that cell,
Press the "=" button to start a cell reference,
Then go to the other sheet that has the subtotal that you want,
Click on the subtotal cell,
Press enter.
Similarly, you can create any type of formula to sum, or sumif, or sumifs in the sheet you want to pull data FROM and just reference it in the sheet you want to pull the data TO.
Or you can just create those formulas in the sheet you want to pull the data TO.
Excel will just make a sheet reference and pull the data across sheets or files. It's not tough.
Have both sheets open,
Create a =sum() formula in a cell in the sheet you want to pull the data FROM,
Go to the sheet that you want that subtotal to be shown,
Choose a cell and put your cursor in that cell,
Press the "=" button to start a cell reference,
Then go to the other sheet that has the subtotal that you want,
Click on the subtotal cell,
Press enter.
Similarly, you can create any type of formula to sum, or sumif, or sumifs in the sheet you want to pull data FROM and just reference it in the sheet you want to pull the data TO.
Or you can just create those formulas in the sheet you want to pull the data TO.
Excel will just make a sheet reference and pull the data across sheets or files. It's not tough.
Posted on 10/3/17 at 11:22 am to Paige
quote:
I tried v lookup but it just grabbed one of the classes instead of the subtotal
Not sure on sum if
The vlookup has to match what the subtotal line is titled. If you used the auto-subtotal function (Found in the outline section of the data tab), then your vlookup will need to look for the social security number followed by the word Total - "111-22-3333 Total". If you manually typed in the subtotal formula, then use whatever you labeled that line.
The sumif function will help you when adding data to the main sheet.
=sumif(range,criteria, [sum_range])
Range: The column where the SSNs are
Criteria: The individual SSN that you want to get the subtotal of
Sum_Range: The column where the amounts to be subtotaled are.
Posted on 10/3/17 at 11:42 am to CubsFanBudMan
Y’all were right!
Sumif worked. I’ve never used it
Sumif worked. I’ve never used it
Posted on 10/4/17 at 3:22 pm to Paige
If you have multiple criteria, sumifs is the next option available. Great formulas, but pivot tables can usually provide the same output in a simpler fashion.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News