In the workbook attached, matches played by Watford both at home and away.
In the last 5 matches played at home, Watford has won 2, drawn in 1, lost 2, scored 8 goals and conceded 8 goals.
In the last 5 away matches, Watford has won 2, drawn in 2, lost 1, scored 6 goals and conceded 6 goals.
In the last 5 Home/Away matches, won 2, drawn in 2, scored 4 goals and conceded 4 goals.

What would be the formula that would calculate these values? The formula should self-update when more results are captured.

Notes:
i. For home calculations, consider only home matches (5 home matches)
ii. For away calculations, consider only away matches (5 away matches)
iii. For Home/Away (H/A), consider only the latest 5 home and away matches by date.
iv. The interval should be tied to cell M1


last five.xlsx