There are 3 excellent SumProduct tutorials as 'Stickies' are the top of the SumProduct sub-forum that have a very good presentation of how to use Sumproduct


http://www.vbaexpress.com/forum/forumdisplay.php?f=98

As well as

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

Paul