Running Total that resets on Mondays

[HeyInKy]

3 semi-related problems:

I have a simple table which records the date in A and a numeric value in B, and I want a weekly running total in C to reset on Monday - WEEKNUM(N,2). Then I want a running, weekly average, which should change only row when new data is entered, not update all rows matching that week. I have a formula for monthly totals in Col. E, but my formula in F for monthly average, isn't a true running average, but updates each cell in the monthly range instead.

Sample Book 1.xlsx

[Root_]

Is this what you need?

=SUMIFS($B$2:B2,$A$2:A2,">="&INT((A2-2)/7)*7+2,$A$2:A2,"<"&INT((A2-2)/7)*7+9)

=AVERAGEIFS($B$2:B2,$A$2:A2,">="&INT((A2-2)/7)*7+2,$A$2:A2,"<"&INT((A2-2)/7)*7+9)

[HeyInKy]

Yes, I think this works! It works even if there's more 7 entries in a given week?