Count of Columns that contain a word

[Clandmann]

Hello!

I am trying to create a new column of data that counts the number of times other columns of data, in the same row, contain a certain word.

In this example, I want to know the number of columns that contain the word "Completed" for each user.

I have been stuck on this for a while so thank you all for the help in advance! 

[OllieClarke · Accepted solution]

Hey @Clandmann 

Have a go with this solution:

If you use the transpose tool, you can then count the number of columns which contain 'completed' per row

Hope that helps,

Ollie

[Clandmann]

This works like a charm! Thank you for the help.