How to calculate weighted average in Excel 2007:
use SUMPRODUCT() function