AVERAGEIF with dynamic range?

Hello

I need to average data that is populated daily. Easy peasy when comes to average each day from day 1, but I need now to be automated process tht will take under cosideration only last 4 weeks and will return average figure for each day of the week.
I have attached what I've done for the total, cant figure out how to determine range that will change daily, for example: from today() check last 4 weeks?

Appreciate any thoughts

Rather than just have headings of day of week, they should be dates: And it appears data is missing for some weeks so what should the result in this case.

Given TODAY() (13 June) is Tuesday, is the average the last 4 weeks from Monday 5th June i.e last week is 4th week.

HI

Pretty much, I said that for example, lets check last 4 Tuesdays, it may be 6 it may be 8, depends on needs, problem is there will be another week of data so we have to go from today() desired number of weeks back. I have date as well but coulndt force AVERAGEIF to work on dates so I added days.

ARRAY formula in CG3, then drag across for average of last 4 entries as required.
Pl see the attached file

Please Login or Register  to view this content.

Thank you
Appreciate it

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.