The formula for the average value and the weighted average value in excel is

Weighted average is often used in daily work. In Excel, the SUMPRODUCT and SUM functions can easily calculate the weighted average. If a company buys a product three times and the quantity and price of each product are different, what is the average price of each product? The weighted average value is used for calculation, as shown in the figure.

A: In excel, the average function is used to calculate the average function:

Average (cell area)

Example: = AVERAGE (A1: A10)

 

The formula for the weighted average is:

= SUMPRODUCT (B2: B4, C2: C4)/SUM (B2: B4)

Or array formula:

= SUM (B2: B4 * C2: C4)/SUM (B2: B4)

Press Ctrl + Shift + Enter after the formula is entered.