Columns B & C

INDEX/MATCH is a standard lookup formula. The MATCH() formula finds the first instance of the searched value and returns a numeric position back to the indexed range.


Column D, F & I

A standard SUMIF() that is summing all the values in a specific column based on spotting the rows that match the symbol in column A.


Column E & H

Another standard SUMIF() adding all the values in the specified column after matching the column A symbol, then dividing that sum by the number of entries overall using a COUNTIF(). It's a "manual average" if you will.


Column G

One of my favorite "trick" formulas. Your last "sell date" isn't always on the last row with a particular symbol, many of the "last" entries are blank in the sell column. This formula is making an array list of all the rows that match the column A symbol and are greater than zero in the sell date column. Then the formula decides which one is the entry furthest down on the sheet and returns that date from column H.




If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.