Excel spreadsheets must be built and multiple formulas used to calculate ... Use the formula =SUMPRODUCT(X1:X10, Y1:Y10)/SUM(Y1:Y10) to calculate the average weighted price. What Is a Mean?

Excel's OFFSET function lets you create a reference that ... and the total and average units sold by that employee (using SUM and AVERAGE with OFFSET). First, I will type an employee ID into ...