This tutorial covers finding the weighted average for data using Excel's SUMPRODUCT function. A step by step example is included with the tutorial.
spreadsheets.about.com