I have a simple budget spreadsheet, with columns C thru N representing months January thru to December.
each row after the headings represents an expense item.
Some items have a known amount each month, such as Internet charge, deducted from bank or credit card without intervention, others vary as the money is spent, eg Food. I load the known amounts automatically for the year at the start of the year. The other amounts spent are added as the money is spent.
I'd like column O, the next column, to be the sum spent to date for each item. Therefore if today's date is in January, the total in column O would be the amount in column C. If today's date is in March, I'd like O to show the total for the columns C, D and E.
I can't find a simple formula to do this. I'm prepared to fix a column to show the month number, or even the rightmost column letter, such as E.