Seeing your response; I think I have totally misunderstood your
question...While using array formulas the blanks are treated as 0..

=SUM((A1:A6=0)*(B1:B6="A")) will return 1

--
Jacob


"Jacob Skaria" wrote:

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