Rolling Calculation

Hi there,

To be honest, I'm not even sure the correct term for this is a Rolling Calculation - it may be something entirely different, but if it is slightly misleading, then it's due to my own lack of knowledge, rather than anything more mischevious!!

I'm currently working on a spreadsheet which illustrates our sales on a Daily basis, vs. Target, among other things.

What I have is one column with Target figures in (for every day of the year) and the achieved/actual figure in the next column. At the end of each month is a total figure and a YTD figure. I want the YTD figure for the Target column to only total up to the point where there is an equivalent Actual figure, so I have a like for like comparison, year on year.

I have attached a sample of this spreadsheet, so as to make some sense of the nonsense I've attempted to outline above!!

If anyone can help with this little conundrum, it would be greatly appreciated.

Many Thanks,

Northumberland81