summing at the bottom

[kenpcli]

I have a summary spreadsheet that pulls data from other spreadsheets within the workbook. How do I get it to sum the current column and place the sum formula, then look at the spreadsheet that I pulled the data from and get that column total and place that formula total below the previous then get the last total to subtract from the previous total and place the difference under that?
[TABLE="width: 1130"]
<tbody>[TR]
[TD]Home Company
[/TD]
[TD]Full Name
[/TD]
[TD]ID Number
[/TD]
[TD]Home Site
[/TD]
[TD]Home Department
[/TD]
[TD]Pay Class Name
[/TD]
[TD="align: right"]12/23/2017
[/TD]
[TD="align: right"]12/30/2017
[/TD]
[TD="align: right"]1/6/2018
[/TD]
[TD="align: right"]1/13/2018
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1130"]
<tbody>[TR]
[TD]PCLI-Corp
[/TD]
[TD]WOLFF, KRISTOPHER
[/TD]
[TD]9733
[/TD]
[TD="align: right"]00
[/TD]
[TD="align: right"]30
[/TD]
[TD]FT Hourly
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]40.25
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"] 40.00
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]WOOD, AMANDA
[/TD]
[TD]9744
[/TD]
[TD="align: right"]00
[/TD]
[TD="align: right"]36
[/TD]
[TD]FT Hourly
[/TD]
[TD="align: right"]40.6
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]40
[/TD]
[TD="align: right"]40.00
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]WORKMAN, JACQUELINE
[/TD]
[TD]9750
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]34
[/TD]
[TD]Hourly 3/4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]33.35
[/TD]
[TD="align: right"]35.15
[/TD]
[TD="align: right"]35.15
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]WRIGHT, TERI
[/TD]
[TD]9775
[/TD]
[TD="align: right"]00
[/TD]
[TD="align: right"]38
[/TD]
[TD]Hourly PT
[/TD]
[TD="align: right"]21.85
[/TD]
[TD="align: right"]20.5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]27.2
[/TD]
[TD="align: right"]27.20
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]STOLTZ, MORGAN
[/TD]
[TD]9776
[/TD]
[TD="align: right"]16
[/TD]
[TD="align: right"]34
[/TD]
[TD]Hourly PT
[/TD]
[TD="align: right"]13.6
[/TD]
[TD="align: right"]17.45
[/TD]
[TD="align: right"]20.75
[/TD]
[TD="align: right"]13.45
[/TD]
[TD="align: right"]13.45
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]IVERSON, MEGAN
[/TD]
[TD]9800
[/TD]
[TD="align: right"]00
[/TD]
[TD="align: right"]38
[/TD]
[TD]Hourly PT
[/TD]
[TD="align: right"]7.7
[/TD]
[TD="align: right"]18.65
[/TD]
[TD="align: right"]21.15
[/TD]
[TD="align: right"]6.3
[/TD]
[TD="align: right"]6.30
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]YOUNG, JOLYNN
[/TD]
[TD]9884
[/TD]
[TD="align: right"]42
[/TD]
[TD="align: right"]34
[/TD]
[TD]Hourly 3/4
[/TD]
[TD="align: right"]33.9
[/TD]
[TD="align: right"]30.3
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]30.00
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]YOUNG, BOBBI
[/TD]
[TD]9885
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]34
[/TD]
[TD]Hourly 3/4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00
[/TD]
[/TR]
[TR]
[TD]Transportation
[/TD]
[TD]YOUNG, KAREN
[/TD]
[TD]9886
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]30
[/TD]
[TD]Hourly 2/3
[/TD]
[TD="align: right"]31
[/TD]
[TD="align: right"]24
[/TD]
[TD="align: right"]30.55
[/TD]
[TD="align: right"]29.25
[/TD]
[TD="align: right"]29.25
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]ZANT, BECKY
[/TD]
[TD]9954
[/TD]
[TD="align: right"]18
[/TD]
[TD="align: right"]34
[/TD]
[TD]Hourly 3/4
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]32.55
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]30.00
[/TD]
[/TR]
[TR]
[TD]PCLI-Corp
[/TD]
[TD]ZIGLER, ROBIN
[/TD]
[TD]9955
[/TD]
[TD="align: right"]00
[/TD]
[TD="align: right"]38
[/TD]
[TD]Hourly PT
[/TD]
[TD="align: right"]7.25
[/TD]
[TD="align: right"]8.95
[/TD]
[TD="align: right"]16.2
[/TD]
[TD="align: right"]14.55
[/TD]
[TD="align: right"]14.55
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13362.25
[/TD]
[TD="align: right"]12810.95
[/TD]
[TD="align: right"]13260.82
[/TD]
[TD="align: right"]13704.35
[/TD]
[TD="align: right"]13,704.35
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]rounding from 3min error
[/TD]
[TD="align: right"](0.02)
[/TD]
[TD="align: right"]0.00
[/TD]
[TD="align: right"] 0.00
[/TD]
[TD="align: right"]0.02
[/TD]
[TD="align: right"]13,704.33
[/TD]
[/TR]
</tbody>[/TABLE]
https://drive.google.com/file/d/1xmuw5raS0yoiBCVFPQKgcqq-maM3eA5A/view?usp=sharing

 

[pmich]

I have a summary spreadsheet that pulls data from other spreadsheets within the workbook. How do I get it to sum the current column and place the sum formula, then look at the spreadsheet that I pulled the data from and get that column total and place that formula total below the previous then get the last total to subtract from the previous total and place the difference under that?


Some more info is needed.
1. 'How do I get it to sum the current column' - What is 'it'?
2. 'How do I get it to sum the current column' - Which is the current column?
3. 'and place the sum formula' - Place in which sheet, in which column and in which row?
4. 'then look at the spreadsheet that I pulled the data from' - What is the name of that source Sheet or the names of all the source sheets?
5. 'then look at the spreadsheet that I pulled the data from' - In which column and in which row you want to 'look at'?
6. 'and get that column total' - What is the name of that column?
7. 'and place that formula total below the previous' - Place in which sheet, in which column? 'below' means what or which row?
8. 'and place that formula total below the previous' - 'the previous' means what or which row and in which column?
9. 'then get the last total to subtract from the previous total' - Is 'the last total' manualy entered or calculated by a formula?
10. 'then get the last total to subtract from the previous total' - Is 'the previous total' manualy entered or calculated by a formula?
11. 'then get the last total to subtract from the previous total' - 'the last total' is found in which column and row ?
12. 'then get the last total to subtract from the previous total' - 'the previous total' is found in which column and row ?
13. 'and place the difference under that' - 'place' in which column and row?
14. You have given 4 dates. But numerical values are given for 5 columns. Why?


If you provide a sample data of the expected result, that will be good.

 

[kenpcli]

I thought I provided a link at the bottom for the data worksheets so you could see what I am looking for.

 

[pmich]

Sorry, I missed to check your Link. Thanks for pointing it out.
In your WorkBook many cells do not display the data pulled by some formula. Only #REF ! is displayed.
Probably you may know that to sum from Row 2 to Row 10 in column G, the formula is =sum(G2:G10).
On the Web you might have come across subtracting Row 15 from Row 14 in Column G by using =sum(G14-G15).
I could not figure out what you are exactly in need of. Some expert may help you by using the information that you have provided so far.