Help with a =Sum() please

[mcmcd99]

I'm trying to tally a quantity of two conditions. Anyone able to tell me where I've gone wrong?
I'm trying to count the number of runs per type within a report.

This works:
=Sum(IIf([Type] Like "arff",1))


These don't:
=Sum(IIf([Run] Like "yes" And [Type]="arff",1))


=Sum(Iif([Run] Like "yes",Iif([Type] Like "arff",1)))

[June7]

LIKE without wildcard might as well be = sign.

If Run is a yes/no type field, don't put yes within quote marks. Value of a yes/no field is either -1 or 0, not text. Actually, don't need the LIKE or = sign with Boolean field.

=Sum(IIf([Run] And [Type] = "arff",1))

[mcmcd99]

Ahh! I see! That is really good to know, thank you.