Counting Formula using Multiple Fields

I’m not sure what the best way to describe this would be, but I hope this example table will get my question across. I am looking for a way to count up the number of Hat Tricks a Player gets automatically based on them having 3 or more Goals in a single Game. Each field of the same name is link across tables. The trouble I’m running into is that I’m limited to one field of reference (I need both Game and Player to be considered) when trying to use a Count function.

Any help would be appreciated.

!

1 Like