Formula to add up items that appear in columns

[Steven_Kryger]

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?

[hayley_coneill]

I have the same question, is this possible?

[Elias_Gomez_Sai]

Check these:

Count multiple keywords in text Ask the community

@HammerOz, @Vernon_Fowler, @Karlstens – I can get you halfway (the easy half) there, but using the inputs from a multi-select field as your keywords is problematic. The easy part is this: The basic formula for counting the number of occurrences of {Word} in {String} is (LEN({String}) - LEN(SUBSTITUTE({String},{Word},"")))/LEN({Word}) That is, you want to subtract the length of {String} with all instances of {Word} deleted. This provides you with the combined length of all instances of {Word} …

Counting linked records in the same table Ask the community

Hi Can anyone help please? I am trying to find a way to count linked records in the same table I think someone may have found a work around but am going around in circles trying to find anything I can understand. Thanks, Maria

Count The Frequency Of Collaborators Ask the community

This is possible to do, although the process is a bit of a kludge. The biggest problem is, as far as I know, there is no easy way to create a universal formula for counting collaborators; instead, you have to create a formula that explicitly counts a specific collaborator and either handle each collaborator in his/her own field, combine all of the formulas in one giant IF() statement, or figure out some other way to handle the data. First, the formula. I assume you have a rollup or lookup fiel…

And others similar: Search results for 'count length' - Airtable Community Forum