I would like a count for County A with type Lend, AB owned.

County Type
A Lend by exit
A Lend by exit, estate, AB owned
A Lend, probate CD
A Lend by exit, estate, AB owned
A Lend by exit, inv, AB owned
B Lend
B Lend by exit, inv, AB owned

Have Excel 2003; doing counts in a diffent tab. What am I doing wrong? Is
it due to the wildcard characters? Open to suggestions.

=SUMPRODUCT(--(May!$X$2:$X$429="A"),--(May!$AF$2:$AF$429="*Lend*AB*"))