asked on
SUMIFS HELP
Folks
I have 3 columns
i)GOALSCORER
j)COMPETITION
k)GOALS SCORED
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
SUMIFS(K5:K13,I5:I13,"ROON
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? :)
I have 3 columns
i)GOALSCORER
j)COMPETITION
k)GOALS SCORED
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
SUMIFS(K5:K13,I5:I13,"ROON
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? :)
Microsoft Excel
Last Comment
Saurabh Singh Teotia
ASKER
ok but i would like my criteria to be reflected horizontally and not by rows
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Here are few tips for your reference about how to create a pivot table...
Pivot Table-1 Example...
Pivot Table Example-2...
This will get you starting in right direction about what you want to do..
Saurabh...