Instances of a String within a Matrix

[Commish]

What I am trying to do is to create a formula that will examine a
matrix and tell me how many times, a cells contains a specific string.

For example, given the range (A2:G13), how many cells contain the
string "A"? In this case, the string "1" may appear either as the
first or last character.

 

[Pete_UK]

Try this:

=COUNTIF(A2:G13,"*A*")

The asterisks are wildcard characters, meaning any character. Note
this is not case-sensitive, so it will count "a" as well as "A".

Hope this helps.

Pete

 

[Commish]

Try this:

=COUNTIF(A2:G13,"*A*")

The asterisks are wildcard characters, meaning any character. Note
this is not case-sensitive, so it will count "a" as well as "A".

Hope this helps.

Pete

Duh. How did I not think of that?! I'm trying to create an array
function. Keep It Simple...

Thanks!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete