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!