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