countifs cells which contain certain letters

**hektisk** · 02-03-2011, 09:44 PM

Hello:

I would like to count how many times a cell in the range q3:q13 starts with 'R'. Is this possible to do with countifs? (I'm using countifs because I want to filter the data more). I was thinking of using the search() function, but I do not believe that this function is compatible with countifs. Do I have to use sumproduct?

I understand that this doesn't work, but this is what I'm trying to accomplish: =countifs(c3:c13,$A3,q3:q13,search("r",q3:q13))

Thank you.

Adam

**jeffreybrown** · 02-03-2011, 09:51 PM

Hi Adam,

Are you looking for...

=COUNTIF(Q3:Q13,"R*")

**davesexcel** · 02-03-2011, 09:52 PM

Try this
=COUNTIF(q1:q8,"r?")

**hektisk** · 02-03-2011, 09:52 PM

I am! It's almost too simple. Thank you!

Originally Posted by jeffreybrown

Hi Adam,

Are you looking for...

=COUNTIF(Q3:Q13,"R*")

**hooper12345** · 10-17-2016, 09:43 AM

How would you alter this to count all cells that contain "R"? I ran this formula as answered and got an number but then noticed other cells contained the letter I was running the formula for and need to make sure it's a true count.

**AliGW** · 10-17-2016, 09:44 AM

Maybe this?

=COUNTIF(Q3:Q13,"*R*")

**FDibbins** · 10-17-2016, 09:59 AM

hooper12345 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.