Subtotal Question (stock spreadsheet)

Hey guys,

New to the site and first post. I have built myself a nice portfolio tracker for my stocks. The one area I'd like to fix if possible is when you make multiple purchases to an individual stock at different share prices. For example, I would like to have a total cost for that stock instead of each separate purchase. I'd like to sum up 3-4 separate columns (not the entire row) in a table with a lot of information. Is there a function for that or would I need to manually do that? I also have charts setup but it lists everything separately so the true total value is not really showing.

I know you can't do subtotals with tables so I converted the table and tried that but that doesn't seem like that is what I'm looking for (unless I'm doing it wrong). I don't want subtotals for each row. I feel like there has to be a simple fix for this.

Anyway, I hope this makes sense and thanks for any help here.

Thanks for the reply Marvin. I'm actually just looking for the sum of a few fields. For example, it would just be the total of MFST and Apple. I was just looking at the consolidate feature and think that is what I might need. Although I'm using the "stock" feature in Excel to get current share prices and other info and think that stops the consolidate feature from working. I was trying not to add another column to add things up but think I will need to do that regardless.

Many thanks Marvin. I wasn't sure if there were any other options but I think the grouping/subtotal is the way to go. Your help was much appreciated.