I came up with a non-array solution (I think) but requires two "dummy columns"
In G2 dragged down
=COUNTIF($C$2:$D2,C2)
In H2 dragged down
=COUNTIF($C$2:$D2,D2) You can hide these two columns if you like.
Then with a unique list of teams in J2:J21, In K2;
=SUMPRODUCT(--($C$2:$D$381=J2),--($G$2:$H$381>(COUNTIF($C$2:$D$381,J2)-5)), $E$2:$F$381)
See attachment
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks