Not sure I have understood your query..

What about using MIN() for the array
{=SUM((range1=condition1)*(range2MIN(result2)))}

OR non-array formula
=SUMPRODUCT((range1=condition1)*(range2MIN(result 2)))


--
Jacob


"JPDS" wrote:

Has Excel always counted blanks under the following condition?:

{=sum((range1=condition1)*(cond2result2))}

where result2 could contain blanks to allow for errors in a calculated result?

I know that I can amend the formula so that blanks are excluded but I never
expected blanks to be counted.

Thanks