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.