I have a list of scorers and how many times they score in each match.

Is there a way to find out the current scoring streak depending on how many games their team has played?

text

The entries in column H are the expected return. More columns will appear between columns F and G.

Row 3 – Player’s team have played 2 games so he is on a 2 game streak
Row 9 – Player’s team have played 3 games and he didn’t score in game 3, so his streak is 0

Googling for similar questions, couldn’t find any. I can work out the best total of consecutive games scores in, but not a current total.