Commendations for wanting to do it on your own. Unless you've already found this one, it's one of the best discussions of SUMPRODUCT on the net

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