I think (hope <g) that you mean
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
your link pulls up this thread (amongst others)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Dave O" wrote in message
ups.com...
The formula is (you'll need to adjust the ranges, of course)
=SUMPRODUCT(--(A1:A10=5),--(B1:B10=10),C1:C10)
For a detailed explanation, do a search on DOUBLE UNARY SUMPRODUCT at
this site:
http://groups.google.com/group/micro...UTF-8&oe=UTF-8