Formula to add up items that appear in columns


#1

I would like to add a column that displays a number (e.g. “3”) based on the number of times a word (e.g. “YES”) appears in 5 specific columns of my base.

How would I do this?


#2

I have the same question, is this possible?


#3

Check these:



And others similar: https://community.airtable.com/search?q=count%20length


Formula: add number of keywords