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
Check out the Formula Handbook template!