I have a simple budget with columns for each month (month 1 to 12) and a Year to Date column at the end.
If it is now say month 3, how do I get my YTD column to just add up the first three columns. I have a cell that tells me what month we are in, so I can use this in the formula, but I cant think of how to write the formula that adds up this specified number of columns.
I want somthing that says it is now month 'x', so add up months 1 to 'x'. Each time I put in the month number, I want to see the YTD sum without changing that formula.
Any help will be appreciated.
Regards, AB
Bookmarks