I am not sure what you mean.

The following article is great for learning/understanding SUMPRODUCT.

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