counting if condition is met

[#1]

I am trying to add number of subtypes if it contains a certain value, like "Noise" or "Animal" etc.

I've used the following expressions, but did not work

=Num(COUNT(WILDMATCH(SUBTYPE, 'NOISE')),'#,##0', ',')

//=IF(WILDMATCH(SUBTYPE, '*NOISE*'), NUM(COUNT(SUBTYPE),'#,##0', ','))

//=NUM(COUNT(wildMatch(text, ‘*Noise*’)))

[swuehl · Accepted solution]

Try

=Sum( Wildmatch(SUBTYPE, '*NOISE*') )

//Wildmatch returns zero if there is no match and 1 if the value is like '*NOISE*'

It would also be helpful to know the context of the expression.