How Do I Count the Number of Occurrences of Text Across Columns?

Chris Hockey

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.

Chris Hockey

@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?

Paul Newcome

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))

Mathieu PERSICO

Hi Chris,

Try this:

=COUNTIF({Select Your Range}, CONTAINS("F", @cell))

=COUNTIF({Select Your Range}, CONTAINS("P", @cell))

Hope this helps!

Chris Hockey

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))

Paul Newcome

@Chris Hockey You are missing a square bracket before your first column name.

=COUNTIF([G. Walter]9:[Jessica C.]9), CONTAINS("F", @cell))

Chris Hockey

@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?

Paul Newcome

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))