Hi everyone,

I am not quite sure if this can be achieved with the SUMPRODUCT() function but I have the following problem. I have a sheet with entries for players that play a number of games in a number of years. I have attached a file with a sample (NRPlayersCalculationExample.xlsx). Colum A contains player names, columns B to K represent the games contain indicators (1, 0) if a player played in a game in a given year or not and column L contains the year. I have inserted the desired result in column M and my attempt in column N. I have also color coded the relevant cells for clarity. I basically need to get the number of players that a player played in a given year but only for those players that the player played in more than one game.

I was thinking something like the formula below should do the trick but it does not.

HTML Code: 
Any ideas would be greatly appreciated!