3 month rolling average with Last Value

Hi Zoe Zhi 

Thank you so much for this, but no. My original formula and yours are doing the same thing but The idea is to calulate rolling 3 month avg every month form last submitted score per ID. 

So May average would be  would be 3 (12(Mar,Apr,May)/4) and the value for ID 1 Score would be =2 

But in June average would be would be 3.8 (19(Apr,May,Jun)/5) and the value for ID1 score would be =3

Like so 

ID   SCORE DATE 

2           3      3/19

1          * 2      4/19

6           3      5/19            May(avg Mar,Apr,May)  3+*2+3+4/4 =   3

3           4      5/19

4           4      6/19            June(avg April May June) 3+4+4+*3+5/5= 3.8

1          * 3      6/19

6           5      6/19

And what I am looking for is to Sum only the last submitted value per ID. and calculate 3 month rolling avg.

Do you think you could help me with this ?