Quote Originally Posted by Zack Barresse
The bum part about Microsoft's SUMPRODUCT() (of course a reason for this forum) is that formula was never really meant to do what its main uses are for.
I don't think that is bum at all. If it had been designed to do (some of these things) you can bet your life it would be far more limited than it is now (just like SUMIF is) precisely because constraints would be designed in.

And of course, it is not actually anything about SUMPRODUCT per se, all of these things (and more) can be done with array SUM formulae.