Hi,
I am currently having a problem getting my YTD Average values in my Excel-sheet.
I want to make a dynamic YTD Average formula, showing the YTD Average value for what ever date I want to look to.
In my formula, as shown below, I can make the date dynamic, but not my values follow for the specific date range (YTD to for example 11th of August).
FORMULA: =(SUMIF(Table1[Date];"<="&TODAY();Table1[Values]))/E3
In Column A I have my dates (the top date are todays date and it follows to an older date when going downwards).
In Column B I have my values (values corresponding to the date in the same row).
Regards
Bookmarks