Here is a tutorial on SumProduct. That will help you to achieve your end result.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Alan