counting if condition is met

Mon, 01 May 2017 18:53:20 GMT

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*’)))

Re: counting if condition is met

swuehl — Mon, 01 May 2017 19:16:48 GMT

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.