Instances of a String within a Matrix

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.
 
P

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
 
C

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top