YTD balance change should pick autimatically

[aravindkm]

Hi All,

could anyone one please help me with a formula where my YTD formula should change automatically with a formula.

for example: if the month is April once I input the month apr in an excel sheet the YTD Balance for pervious month should automatically sum the balances of Jan+Feb+Mar subsequently each month it should automatically sum up.

Thanks in advance