Hi. So you have a column of football results. WIN, DRAW or LOSE. Win is worth 3points, Draw 1.
Two criteria. ALL games or LEAGUE games only.
You want to add up the points gained from the most recent 5 matches in both categories.
I've attached an example workbook.
Questions.
1) Do I need Columns D and F or can I add up the W and D. Maybe COUNTIF W*3 and D?
2) Can I use A24 to dictate how many results are looked at?
3) This is the real sticky one. As results are added, is it possible for the formula to move to include the new result so the figure put in A24 works from the bottom up? I was thinking maybe with the DATEDIF and NOW option but there may be a simpler way?
I've included a small example but the actual workbook has over 5000 rows and I maybe want to look at a lot more rows than 5 from time to time.
Many thanks.
Bookmarks