YTD Dynamic Calculation

New Contributor



I want a help to calculate YTD dynamically in which it should always start calculate from January month only no matter January month falls in which cell or column in a provided range (here i want the solution in automatic manner in which i don't need to increase/decrease any range)




Thanks in advance



4 Replies


Let's say that the months are in B1:M1, and the numbers in B2:M2.

The YTD is given by


@Hans Vogelaar 


its giving me an error.




best response confirmed by YashR1994 (New Contributor)


1) Make sure that the cell with the formula is not formatted as text.

2) If you use comma as decimal separator, use semicolon in the formula:




3) Try confirming the formula with Ctrl+Shift+Enter.

@Hans Vogelaar 


Thanks its now working for me