Hi everyone
I’m just beginning to get the hang of some functions in excel and I haven’t had to resort to asking this board for help…
Until now. Here’s what i’m trying to do.
In the file you can see i’m attempting to set up a dynamic match rating football system. Each team takes points off one another with all teams starting at 1000 to give them a relative strength. Each side contributes a % of their total spoils are distributed according to whether the match is a home/away win or draw.
My problem is that by using SUMPRODUCT, it is summing all the occurrences of the criteria being met (if you drag I14:M14 down you'll see what I mean; the average for all 24 teams should be approx 1000), whereas I’m only looking for the last occurrence in each case (the last time the criteria of ‘team name’ was met. How do I have excel only count the last event of met criteria?
I’d also like to know how to sum the last six occurrences for a separate task.
Any advice/help would be appreciated. Hope my question makes sense.
Bookmarks