How to add up prices of certain columns

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 $800, baseball $1200, football $1000. Any help is much appreciated. Thank you

1 Reply


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