Count occurrences, from last 10 which meet criteria

Not sure if the title is the best way to describe this but basically I have a spreadsheet of basketball fixtures (results and upcoming) for the whole league and want to find how many a particular team has won out of their last 10.

What I want to do is find the last 10 rows which A(have been played, ie have score), B(contain the team name which is being looked up, ie they played)
Out of these 10 I want to count the number of which were won (winning team is in a column).

More info can be given if needed. Once I know how to do this, related problems should also be solved.

Thanks in advance for any help.

nbateams.xlsx

Using your posted workbook, this regular formula, copied down, begins the list of Num-of-wins-in-Last-10-games:

Please Login or Register  to view this content.

Is that something you can work with?