Excel's AGGREGATE function ... Your aim is to work out the average game-per-goal ratio for all the players combined. If you were to use the AVERAGE function alone by typing: =AVERAGE(Player ...

Nick David / Getty Images There is no specific formula in Excel or other ... column Y. Use the formula =SUMPRODUCT(X1:X10, Y1:Y10)/SUM(Y1:Y10) to calculate the average weighted price.