The average or arithmetic mean is determined by finding the sum of the numbers in the cell range 80 and then dividing the sum by how many numbers make up the range 10 or 80 10 8. Multiply each transaction price by the corresponding number of shares. I may have autofilter enabled on item occurence tab and I may want to see only the average price for the items shown.
Average Cost per share Total purchases 2750 total number of shares owned 5661 4858.
If you want to calculate stock profit please use the Simple Stock Calculator. Shares BoughtPurchased Price nth 3. Determine the total price of the entire lot of product. Using the formula above calculate the price per unit.