Jan 19 2022 06:10 AM
I have a spreadsheet with 6 columns:
1 - Monday totals
2 - Tuesday totals
3 - Wednesday totals
4 - Thursday totals
5 - Friday totals
6 - Difference
For #6, I need a formula that takes Monday totals and subtracts Tuesdays, then Wednesdays, then Thursdays, etc. So it would be one formula that calculates this on a daily basis once I update one of the numbers.
Is there such a formula?
Thanks
Jan 19 2022 06:32 AM
=SUM(INDIRECT("A2:A"&COUNTA(A:A)))-SUM(INDIRECT("B2:B"&COUNTA(B:B)))-SUM(INDIRECT("C2:C"&COUNTA(C:C)))-SUM(INDIRECT("D2:D"&COUNTA(D:D)))-SUM(INDIRECT("E2:E"&COUNTA(E:E)))
Maybe with this formula as shown in the attached file.
Jan 19 2022 07:05 AM
Jan 19 2022 07:09 AM
Jan 19 2022 07:19 AM
Jan 19 2022 07:53 AM