Hi All, This is my 1st thread so please bear with me...
I am stuck with trying to calculate YTD using a spilled array formula
Cell B1 is a spilled formula from available months that have data in another sheet
Cells B2 & B3 are also spilled using using =sumifs & =countifs
What i need to do is have a formula that will add the YTD totals dynamically ie now it will add up jan to may. When June is added dynamically i want the formula to spill and add those figures in the relevant cell.
i would be really grateful for some advise on how to do this!