I have a worksheet that details sales results by actual data and budget % for each month.

I am trying to create a YTD calculaiton, that will sum the actual results, but only up to the month that I specify in a separate cell.

Eg. If I set the month as April, then the YTD should calculate Jan - Apr results but it will the data results only, therefore every 2nd column.


Is there a formula to do this as I am having trouble comining the 2 parts to this?

Thanks