Hi ...

I have this formula: =SUMIFS(Stats[HS];Stats[HomeTeam];$B$8)

I want to copy it horizontally, but the [HomeTeam] keeps changing to the next column in the table/array
How do I stop that from happen?

In advance; Thanks