Forum Discussion
Need a formula that has a running calculation
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 t...
=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.
Thanks I'll try!