How Do I Count the Number of Occurrences of Text Across Columns?
I am trying to count the number of instances that certain text occurs across columns in a sheet. How do I count the number of "F"s, and "P"s across these columns.
Best Answers

@Paul Newcome I am still getting the same #UNPARSEABLE error with that change:
=COUNTIF([G. Walter]9:[Jessica C.]9), CONTAINS("F", @cell))
Does it matter that the cells are dropdown menus?

My apologies. I missed the extra closing parenthesis in the middle of the formula.
Try this one...
=COUNTIF([G. Walter]9:[Jessica C.]9, CONTAINS("F", @cell))
Answers

Hi Chris,
Try this:
=COUNTIF({Select Your Range}, CONTAINS("F", @cell))
=COUNTIF({Select Your Range}, CONTAINS("P", @cell))
Hope this helps!
Mathieu  Workflow Consultant
info@evolytion.com

Thanks Mathieu,
When I enter that formula, I get an #UNPARSEABLE error. Here's what the formula looks like when entered in my sheet.
=COUNTIF(G. Walter]9:[Jessica C.]9), CONTAINS("F", @cell))

@Chris Hockey You are missing a square bracket before your first column name.
=COUNTIF([G. Walter]9:[Jessica C.]9), CONTAINS("F", @cell))

@Paul Newcome I am still getting the same #UNPARSEABLE error with that change:
=COUNTIF([G. Walter]9:[Jessica C.]9), CONTAINS("F", @cell))
Does it matter that the cells are dropdown menus?

My apologies. I missed the extra closing parenthesis in the middle of the formula.
Try this one...
=COUNTIF([G. Walter]9:[Jessica C.]9, CONTAINS("F", @cell))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.4K Get Help
 61 Global Discussions
 46 Industry Talk
 384 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!