How to calculate weighted average in Excel 2007:

use SUMPRODUCT() function