SubStringCoun

[kadifr2008]

Hello, i am using this formula to count the text. The issue is that in data column "status" i have : Performed and Performed Late. the formula is counting both( performed late and performed). How count only performed. Thank you

sum( if( SubStringCount( Status, 'Performed'),1,0) )

[rwunderlich · Accepted solution]

Does the status column contain "Performed" by itself? Can you just do:

sum( if( Status =  'Performed',1,0) )

-Rob