The form I use for ratings has up to 10 runs for each horse but I only want to look at the last 3 for part of the rating. I can use a countifs formula to get what I need from all 10 but I want to look at just the last 3 runs. The runs are in rows for each horse (listed alphabetically) showing the most recent run at the top.

If anyone can help it would be appreciated.