I want to automate a sum to take account of each month as each month passes.
For example, I have a 'Year to Date' column that I want to automatically
update when I change the reporting month, so if I entered 'May' the column
would sum the range from Jan to May.

Please help.