For example:
In May, I want to take current cumulative figures from January-May (cells B*-F*) for this year and then add the cumulative figures for June-December of last year where * equals the row number.
In June, I will need to take current cumulative figures from January-June (cells B*-G*) and add the cumulative figures for July-December from last year (cells AB*-AG*).
Bookmarks