Hi Team,

Need your help , in sumproduct formula, I want Count of Partial Match.

and also how to use not Equal in Partial Match using wild Card.

Below excel formula gives correct result. for Exact Match. Need some change in Third Criteria. highlighted in bold.

=SUMPRODUCT(ISNUMBER(MATCH($A$1:$A$100,$E$2:$E$4,0))*ISNUMBER(MATCH($B$1:$B$100,$F$2:$F$4,0))

G2 Contains value = Pending

I am trying like this. looking for Total Count which does not Contain Partial Match word *Pending*

*ISNUMBER((MATCH($C$1:$C$100,"

for Criteria *ISNUMBER((MATCH($C$1:$C$100,$G$2,0))

Plz assist Thanks.

Regards,

mg

Need your help , in sumproduct formula, I want Count of Partial Match.

and also how to use not Equal in Partial Match using wild Card.

Below excel formula gives correct result. for Exact Match. Need some change in Third Criteria. highlighted in bold.

=SUMPRODUCT(ISNUMBER(MATCH($A$1:$A$100,$E$2:$E$4,0))*ISNUMBER(MATCH($B$1:$B$100,$F$2:$F$4,0))

***ISNUMBER((MATCH($C$1:$C$100,$G$2,0))))**G2 Contains value = Pending

I am trying like this. looking for Total Count which does not Contain Partial Match word *Pending*

*ISNUMBER((MATCH($C$1:$C$100,"

***<>Pending*"**,0))for Criteria *ISNUMBER((MATCH($C$1:$C$100,$G$2,0))

Plz assist Thanks.

Regards,

mg

Last edited: