Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

To calculate a price-weighted average, sum the stock prices and divide by the number of stocks. This average reflects changes in higher-priced stocks more than lower-priced ones. Use price ...

The average price you paid for a stock is important information. Check out this step-by-step guide to learn how to calculate an average stock price.