Hi,
try

=SUMPRODUCT((range1=condition1)+(resul2=con2))


"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