I am trying to find out the average output of my business for the most recent month and year to date. I was wondering how you might make this sort of rolling average. Currently I had gone for using the averageifs function but am not too sure about syntax.
If anyone has any advice, that would be greatly appreciated!
@Twifoo Thank you for the reply. Yes I would like to get the weekly average for the yearand then also for the month so I assume I would be just changing it to TODAY()-30
Trouble is I'm not actually getting anything
Your formula is trying to return the projected total output for the next 360 days. To return the historical output for the last 1 month before today, your formula should be:
For the last 1 year before today, your formula should be:
Your current formula is returning #DIV/0! error probably because there are no dates in the Week Ending column of Table5, which are after today.