Counting Columns based on if they contain certain words/names



I have a worksheet that has several columns, what I am trying to do is count 1 column IF it holds "specific text/words"

then to add onto this I need it to only count if a name shows up in 1 of 3 other columns.

I've tried 15 different formulas now and none of them seem to be working. I thought it would be as simple as a "countif with a contains (OR)" obviously thats not how id written the formula out

Can anyone help me out?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!