Hi,

does anyone know a formula i can use to expand a sum range depending the finacial week.
eg if its week 10 i need to sum week 1-10 but then once its week 11 i need to formula to sum week 1-11

sample spread sheet attached

thanks
YTD sum.xlsx