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?
<tbody>
</tbody>
<tbody>
</tbody>https://drive.google.com/file/d/1xmuw5raS0yoiBCVFPQKgcqq-maM3eA5A/view?usp=sharing
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>
Last edited: