PDA

View Full Version : Applications of SUMPRODUCT



Cyberdude
08-05-2006, 02:22 PM
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.

matthewspatrick
08-06-2006, 06:08 PM
This is the best write-up on the undocumented uses of SUMPRODUCT I've ever seen:

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

mdmackillop
08-07-2006, 09:46 AM
Agreed!

Cyberdude
08-08-2006, 01:16 PM
Matthewspatrick, that is indeed a grrrrreat reference ... just what I wanted! Thanx, guy. :friends:

Zack Barresse
08-09-2006, 02:38 PM
Also, a very good resource for it is this post by Aladin Akyurek ...

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

Cyberdude
08-15-2006, 08:23 PM
Thanx, FF. It is a good reference, and I have printed it out.