Summary Help

Hello,

I am trying to complete a my works Bradford Factor template, and I'm having trouble with the formula for my summary.

Currently I have a column which has data from periods of sickness, but I need my summary to just reflect the latest data deducting the current data for example:

Column 1 - 1
Column 2 - 12
Column 3 - 36
Column 4 - 96
up to Column 10.

In my summary I need the formula to read the latest period of data 96, and I need this to complete automatically without having to re-formula each time. . .

I have included a copy of my workbook. Absence Workbook.xlsx

Can anyone help please?

Many Thanks in advance.

Thanks, I'll give it a try