Instances of a String within a Matrix

  • Thread starter Thread starter Commish
  • Start date Start date
C

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.
 
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
 
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
Click to expand...

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

Thanks!
 
Back
Top