Spreadsheet: 101102d1299255423-trying-to-return-a-year-to-date-amount-offset-tutorial
Sheet: YTD Example

www.thefinancialmodeler.com
[NAME] example using OFFSET
Compute Year-To-Date Results
Last Month of Actuals |  |  |  | Feb
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total Year | YTD | YTD%
 |  |  |  | Actuals | Actuals | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
Revenues
 | Product A |  |  | 3494.126391901922 | 10800.39627451685 | 4105.050761445715 | 15375.67548791056 | 9648.69642695534 | 3061.572626528499 | 10082.02436033841 | 3296.066507462607 | 5488.152094423924 | 16135.73648803145 | 4328.08917958296 | 13169.17747067441 |  | 98984.76406977267 | 14294.52266641877 | 0.1444113425005772
 | Product B |  |  | 3380.79432267109 | 11769.89923770464 | 6328.3543567741 | 17774.80237910294 | 3008.660972971343 | 7723.710493208278 | 5662.462967263431 | 20001.37220117993 | 1680.779530517682 | 11869.81861350381 | 19214.7174118825 | 17139.17430838805 |  | 125554.5467951678 | 15150.69356037573 | 0.1206702102560481
 | Product C |  |  | 8918.681501925612 | 29476.17631996326 | 24928.24886245903 | 47205.25280714903 | 2840.764169011748 | 12915.61816148909 | 52529.23642489851 | 40769.28886725536 | 6209.249385616077 | 15019.6846255325 | 5086.973748708617 | 678.8982870191718 |  | 246578.073161028 | 38394.85782188887 | 0.1557107545276951
 | Total |  |  | 15793.60221649862 | 52046.47183218475 | 35361.65398067884 | 80355.73067416254 | 15498.12156893843 | 23700.90128122587 | 68273.72375250034 | 64066.72757589789 | 13378.18101055768 | 43025.23972706776 | 28629.78034017407 | 30987.25006608163 |  | 471117.3840259685 | 67840.07404868337 | 0.1439982398207236
[NAME]
 | Product A |  |  | 2792.948363373117 | 8389.789430141705 | 3536.168310790776 | 13041.64022608077 | 6289.208313307979 | 2262.527773794996 | 8452.076277438615 | 2570.985312838417 | 3547.291058329527 | 10978.02075688296 | 3324.739043153842 | 8006.835606108894 |  | 73192.23047224162 | 11182.73779351482 | 0.15278585884544
 | Product B |  |  | 2353.231994819861 | 11625.19977838377 | 6075.476942215422 | 11535.45380384008 | 2810.117734650514 | 7352.431985504556 | 4232.789254126301 | 17012.86178003278 | 968.528754481182 | 9660.241029824763 | 13185.81178612351 | 13143.82124152881 |  | 99955.96608553155 | 13978.43177320363 | 0.1398458973548651
 | Product C |  |  | 4998.553600577218 | 17810.76721030534 | 15209.63915477696 | 35221.31252874915 | 2560.591759532233 | 11458.12914509762 | 35690.06071918573 | 38844.96157068084 | 3994.313768641488 | 12801.1660295823 | 2950.113574487475 | 566.8696830433089 |  | 182106.4787446597 | 22809.32081088256 | 0.1252526596973225
 |  |  |  | 10144.7339587702 | 37825.7564188308 | 24821.28440778315 | 59798.40655867001 | 11659.91780749073 | 21073.08890439717 | 48374.92625075065 | 58428.80866355203 | 8510.133581452197 | 33439.42781629002 | 19460.66440376482 | 21717.52653068101 |  | 355254.6753024329 | 47970.490377601 | 0.1350312711205366
Gross Margin |  |  |  | 5648.868257728427 | 14220.71541335394 | 10540.36957289569 | 20557.32411549253 | 3838.203761447703 | 2627.812376828697 | 19898.79750174969 | 5637.918912345864 | 4868.047429105485 | 9585.811910777738 | 9169.11593640925 | 9269.723535400619 |  | 115862.7087235356 | 19869.58367108236 | 0.1714924835608144
Other Costs |  |  |  | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 | 3366 |  | 40392 | 6732 | 0.1666666666666667
EBITDA |  |  |  | 2282.868257728427 | 10854.71541335394 | 7174.369572895688 | 17191.32411549253 | 472.2037614477031 | -738.1876231713031 | 16532.79750174969 | 2271.918912345864 | 1502.047429105485 | 6219.811910777738 | 5803.115936409249 | 5903.723535400619 |  | 75470.70872353564 | 13137.58367108236 | 0.1740752656664186
 |  |  |  | 0.1445438619027426 | 0.2085581410465858 | 0.2028855770382141 | 0.2139402376316167 | 0.03046845124728541 | -0.03114597265362401 | 0.2421546181029012 | 0.03546175992295519 | 0.1122759086545556 | 0.1445619350463437 | 0.2026950911763079 | 0.1905210537498706 |  | 0.1601951260609301 | 0.1936552083014322
You can also check out these features
 |  | Data validation in cell $E$5 and how it interacts with:
 |  | - Month subtitles
 |  | - Conditional formatting of months with actual results