ub,

I probably might not hear from you again, but felt compelled to post a
clarification here.

If sumproduct works for you on the data-sets that you have, there's no
reason why your original 2 conditional array formulas won't or didn't, as
per the quick sample provided in my 2nd response in the other branch.

The key facility/difference is that sumproduct works on conditional arrays
but doesn't* require array-entering while your original array formulas need
array-entering.
*except where TRANSPOSE is used within
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---