One difference is that you cannot use a straight forward IF in sumproduct
assume
you have this formula
=SUMPRODUCT(--(A1:A660),--(B1:B6="a"),C1:C6)
which will total c1:c6 if certain conditions in A and B are fulfilled
However if there would be an error like #N/A in C it will return that error
This array formula would fix that
=SUM(IF(A1:A660,IF(B1:B6="a",IF(ISNUMBER(C1:C6),C 1:C6))))
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"JimMay" wrote in message
news:8PXkg.41424$fG3.28516@dukeread09...
I use the Sumproduct() function extensively;
Obviously, there are also in use, significant Control-Array
Formulas (which I have used, but less often). Can
Someone tell me the what differentiates the two?
At some point (it seems) the Sumproduct lacks what
The CSE formulas can do, but I cannot express or explain it.
Any clarification would be appreciate.