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?

Home Company

Full Name

ID Number

Home Site

Home Department

Pay Class Name

12/23/2017

12/30/2017

1/6/2018

1/13/2018

<tbody>
</tbody>

PCLI-Corp	WOLFF, KRISTOPHER	9733	00	30	FT Hourly	40	40	40.25	40	40.00
PCLI-Corp	WOOD, AMANDA	9744	00	36	FT Hourly	40.6	40	40	40	40.00
PCLI-Corp	WORKMAN, JACQUELINE	9750	20	34	Hourly 3/4			33.35	35.15	35.15
PCLI-Corp	WRIGHT, TERI	9775	00	38	Hourly PT	21.85	20.5		27.2	27.20
PCLI-Corp	STOLTZ, MORGAN	9776	16	34	Hourly PT	13.6	17.45	20.75	13.45	13.45
PCLI-Corp	IVERSON, MEGAN	9800	00	38	Hourly PT	7.7	18.65	21.15	6.3	6.30
PCLI-Corp	YOUNG, JOLYNN	9884	42	34	Hourly 3/4	33.9	30.3	30	30	30.00
PCLI-Corp	YOUNG, BOBBI	9885	20	34	Hourly 3/4					0.00
Transportation	YOUNG, KAREN	9886	20	30	Hourly 2/3	31	24	30.55	29.25	29.25
PCLI-Corp	ZANT, BECKY	9954	18	34	Hourly 3/4	30	30	32.55	30	30.00
PCLI-Corp	ZIGLER, ROBIN	9955	00	38	Hourly PT	7.25	8.95	16.2	14.55	14.55
						13362.25	12810.95	13260.82	13704.35	13,704.35
					rounding from 3min error	(0.02)	0.00	0.00	0.02	13,704.33

<tbody>
</tbody>

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.