# Countif - text begins with the letter __

This is a discussion on Countif - text begins with the letter __ within the Excel Questions forums, part of the Question Forums category; Hi there, I am using a countif formula to answer the question: How many Entries begin with the letter "i"? ...

1. ## Countif - text begins with the letter __

Hi there,

I am using a countif formula to answer the question: How many Entries begin with the letter "i"?

The formula I am using is =countif(left(C2:C101,1),"I") but I am getting an error return

Do you know what I am doing wrong? How else could I find out how many of the entries begin with the letter "I"?

Thanks!

Spinner

2. ## Re: Countif - text begins with the letter __

You can't apply a function to the range in countif..

Try using a wildcard

=COUNTIF(C2:C101,"I*")

3. ## Re: Countif - text begins with the letter __

Ok thanks! I didn't know about wildcards.

Could I use * to find entries that are only one word entries?

As an example it would return "Fries" --> One word
but would not return "Fries and Gravy" --> Three words

Sppinner

4. ## Re: Countif - text begins with the letter __

In that case, you would NOT use the wildcard, and just use "Fries"

=COUNTIF(C2:C101,"Fries")

5. ## Re: Countif - text begins with the letter __

I am trying to apply it to a long range of entries so I would need it to be able to answer the question: How many entries are made up of only one word?

I'm thinking of something like =countif(c2:c101, and("?*?",not("?*? ?*?")))

Spinner