How to add up prices of certain columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2140662%22%20slang%3D%22en-US%22%3EHow%20to%20add%20up%20prices%20of%20certain%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140662%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20full%20of%20sports%20cards%20with%20categories%20like%20name%2C%20set%2C%20price%20paid%2C%20etc.%20I%20want%20to%20create%20another%20table%20that%20shows%20how%20much%20i%20spend%20on%20each%20sport.%20For%20example%3A%20say%20i%20have%20recorded%20info%20on%205%20different%20cards%20i%20just%20bought.%202%20are%20mahomes%20for%20%24500%20each%2C%202%20are%20mike%20trout%20for%20%24600%20each%2C%20and%201%20is%20Lebron%20James%20for%20%24800.%20I%20want%20to%20create%20a%20table%20that%20will%20automatically%20update%20how%20much%20i%20have%20spent%20in%20each%20sport.%20So%20I'd%20like%20the%20table%20to%20say...basketball%20%24800%2C%20baseball%20%241200%2C%20football%20%241000.%20Any%20help%20is%20much%20appreciated.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2140662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a table full of sports cards with categories like name, set, price paid, etc. I want to create another table that shows how much i spend on each sport. For example: say i have recorded info on 5 different cards i just bought. 2 are mahomes for $500 each, 2 are mike trout for $600 each, and 1 is Lebron James for $800. I want to create a table that will automatically update how much i have spent in each sport. So I'd like the table to say...basketball $800, baseball $1200, football $1000. Any help is much appreciated. Thank you

1 Reply

@bryanjohns18 

It looks like PivotTable will do the job, but better to discuss having sample file.