Count the number of columns that contain a value

Say you have three columns that you want to find if a value exists in, then count the columns that contain that string.

In my list, I created three columns.

cOne, cTwo, cThree

All have a field type of single line of text.

Then I created a calculated column named cCalc.

The formula for cCalc is:


In my formula, I’m searching each field for the word Taco. ¬†Keep an eye on your case usage. ¬†Taco is not the same as taco.

Find function:

Count function:

Leave a Reply

Your email address will not be published. Required fields are marked *