I have 3 columns
I have thousands of different goalscores but would like summarize the amount of goals scored per goalscorer per competition
this works with a sumifs function
but given having thousands of goalscores, how can i dympacially sumamrize the unique goalscorers without having to hardcode the formula for each goalscore i.e. "ROONEY"
hope the truth is out there? :)