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?