I have made a table (see below), When we have finished our round, we determine what team made birdies, If no other team birdies the same hole then your team wins the hole, I have cond. formatted to highlight in red if two or more teams birdie the same hole. that will cancel that hole out. What i would like to do if possible is, keep up with when a team does win. EX. If TEAM 1 wins hole 1,4,6,8 and those were the only birdies that were not covered, then i can plug in the formula to show total number of skins,(4) dollar amount allocated to skins.($6) multiplied by number of players that day. Im Stuck! I have watched 30 or so videos and mostly they deal with number values and can’t seem to figure out how to do this. attached is the spreadsheet. The part in question is on sheet 2. HOLE 1 2 3 4 5 6 7 8 9 Skins Amt Money Team 1 x x x x x Team 1 Team 2 x x Team 2 Team 3 Team 3 Team 4 x x Team 4 Team 5 x