I have a spreadsheet that has columns for each day of the week, as well as WeekToDate (WTD) and YTD totals. The WTD column is calculated based on the sum of the Monday - Sunday columns.
YTD = Column J
The data in col. J here is manually entered.
What I'd like to do is to have the YTD column represent the sum of the WTD from row 2 (the first data row) to the current row.
e.g. J5 would be SUM(I2:I4)
e.g. J6 would be SUM(I2:I5)
In general terms:
J<row#> would be SUM(I2:I<row#>)
Is there a (simple) formula for this calculation?