Average Score for last 30 days, 60 days, etc.

[kublaieod]

I have attached a workbook where I need to track scores on a rolling 30,60,90 days. Since the score are erractic as to when they are entered I can't just use an average formula (at least I think).

DASHBOARD Tab - I need to be able to count the number of test in a rolling 30 day period (results in B3,C3,D3)
and Average the scores in those ranges (results in B5,C5,D5

OVERALL SCORES Tab - contains the data.


How to I enter the formula to tabulate both the number of tests over a rolling period and enter the average score for that rolling period.

I greatly appreciate any assistance.Test Analysis.xlsx

[PAUL P ACHUMI]

Hi,
I'm not sure if this is what you're looking for but, give it a try