Forum Discussion
Help with Formula to count game points
Hi, I'm a soccer mum with little excel smarts. I'm collecting each game from the team who were the top 3 players for the game and assigning them 3 points for best, 2 points for 2nd best and 1 point f...
CGallagherInner Another option is the SUMPRODUCT function. Input the following formula in cell B24 and copy down:
=SUMPRODUCT(($B$3:$D$21=A24)*$B$2:$D$2)