List Calculated Column - Count Text

[akrshaw]

I have the following list:

File Name [tab][tab]Review 1 [tab] [tab]Review 2 [tab][tab][tab][tab]Review 3 [tab] #
001_SOC [tab]Jones/Working [tab] Nelson/Complete [tab] Haim [tab][tab][tab] 1


I need to count the number of Review columns that contain the word complete.


I need to count the number of Review columns that contain the word complete.

 

[ehaze]

cOne, cTwo, and cThree are my column names.

Place this string in a calculated column.
=COUNT(FIND("Complete",cOne),FIND("Complete",cTwo),FIND("Complete",cThree))

http://www.sharepointed.com/2013/12/27/count-the-number-of-columns-that-contain-a-value/

http://www.sharepointed.com/