Applications of SUMPRODUCT

I know pretty much what the basic function (so to speak) of SUMPRODUCT is, but I've noticed that several of the gurus offer it as the solution to all kinds of problems. Is there a good reference somewhere that goes into detail about various applications of this function? I can't seem to get a feel for how to use it in other than the most basic ways.

This is the best write-up on the undocumented uses of SUMPRODUCT I've ever seen:

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

Agreed!

Matthewspatrick, that is indeed a grrrrreat reference ... just what I wanted! Thanx, guy. :friends:

Also, a very good resource for it is this post by Aladin Akyurek ...

http://www.mrexcel.com/wwwboard/messages/8961.html

Thanx, FF. It is a good reference, and I have printed it out.