Calculate running averages, according to criteria in other cells

[ollyhughes1982]

Hi,

I wonder if anyone might be able to help, please. I have the below worksheet and need to come up with a formula to populate the yellow highlighted column (AD).

Basically, I want to have a running average for each individual week’s-worth of runs. i.e. When each week ends, I want the average for just that week to appear in all rows for that particular week. I have identified the unique weeks in column Z, so you can identify when the current week ends and the next begins.

The file example is available here: Weekly Average Times.xlsx

Thanks in advance,

Olly.

 

[Fluff]

How about

=AVERAGEIFS(H:H,B:B,">="&X4,B:B,"<="&Y4)

 

[ollyhughes1982]

How about

=AVERAGEIFS(H:H,B:B,">="&X4,B:B,"<="&Y4)

Yip, that worked perfectly. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.