Provide a month to date total based on the day of the month
Posted on 2011-03-01
I'm developing a spreadsheet to provide a sum of income & expenses for the month to date, where the table has income/expenses budgeted by days across in columns and the line detail down in rows.
There is a description in column D, a budget figure for the whole month in column E, with the monthtodate value for that row in column F and days 1 to 31 in subsequent columns, where each days values are entered.
On day 1 the spreadsheet table will show all the figures as budgets and if you sum the MTD totals (horizontally) this will show the same value as the budget column. However the MTD column will only show the value of day1 for each row.
On day 2 the MTD column will now show the sum of days 1 to 2 for the row in question.
Row 2 holds the Day number for the month
I have got so far in the formula in cell
How do I reference the sum(G5:AK5) in each cell on row 5 to reflect the sum according to the day of the month?