Page 1
Page 1
Posted by
Message
Paige
LSU Fan
Vice President of the OT
Member since Oct 2010
75602 posts

Is there an Excel formula to get the subtotals from one sheet onto another sheet?
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

CubsFanBudMan
Chicago Cubs Fan
Member since Jul 2008
3342 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
You can probably either use vlookup or sumif. I would go with sumif.

Paige
LSU Fan
Vice President of the OT
Member since Oct 2010
75602 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
I tried v lookup but it just grabbed one of the classes instead of the subtotal

Not sure on sum if

Mahootney
Florida State Fan
Lovin' My German Footprint
Member since Sep 2008
6988 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
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.

Replies (0)
Replies (0)
60
CubsFanBudMan
Chicago Cubs Fan
Member since Jul 2008
3342 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
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.

=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.

Paige
LSU Fan
Vice President of the OT
Member since Oct 2010
75602 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
Y’all were right!

Sumif worked. I’ve never used it

seawolf06
LSU Fan
Raleigh, NC
Member since Oct 2007
6287 posts

re: Is there an Excel formula to get the subtotals from one sheet onto another sheet?
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.

Replies (0)
Replies (0)
10
Page 1
Page 1 of 1