Can anybody help please??
I have 13 colums labled Jan, Feb, March etc, the 13th column labled total. I also have 15 rows labled Name 1, Name 2 etc,creating a block of 195 cells (less Lables).
In each cell I want to enter the days absent for each name per month, on the 13th column it will show the total absents for that year, no problem but this has to be a Rolling Year so when I enter january of the next year it will move accross the columns starting with Feb,March etc and calculation the total for the 12 months only.

I have tried everything to make this work.