Find number of 0's in 0/1 collumn depending on username

Hey excelforum

I need some help with a formula for a data set I知 working on.
I知 looking at data from a surgical simulation, and needs to know how many failed simulations a participant has had within the last 3, 5 and 10 simulations.
So I have a column containing the results (0=fail/1=succes) and another column containing the corresponding usernames used in the simulation.
My problem is that sometimes the usernames are scrambled/mixed (but they all have date_time stamp) and therefore the formula has to be able to consider all previous results by a specific username (even though they might not be the previous rows) and tell me how many fails a user has had within the last 3, 5 or 10 simulations.
Part of the problem is that the usernames are stacked on top of each other in the username collumn. This means that for the first entry of a given username the formula needs to take into account that there is no previous results by this username to analyze.

Hope you guys can help
Thanks!