How to add up prices of certain columns

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...