What is the formula to count cells with specific text

[Guest]

What is the format of the excel function to count cells with specific text in the cell. I have a column on my spreadsheet that has some data in the cells starting with the letters "wo". There are more letters and numbers after the letters "wo". I need to count the cells that start with the lettes "wo". What is the function and format of the command to count the cells on my spreadsheet with the letters "wo"

Thanks Confused

 

[Paul B]

confused, here is one way, =COUNTIF(A1:A10,"wo*")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

What is the format of the excel function to count cells with specific text

in the cell. I have a column on my spreadsheet that has some data in the
cells starting with the letters "wo". There are more letters and numbers
after the letters "wo". I need to count the cells that start with the
lettes "wo". What is the function and format of the command to count the
cells on my spreadsheet with the letters "wo"?

 

[Bob Phillips]

Just in case you only want lower-case 'wo' not all combinations, you can use

=SUMPRODUCT(--(NOT(ISERROR(FIND("wo",A1:A10)=1))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

What is the format of the excel function to count cells with specific text

in the cell. I have a column on my spreadsheet that has some data in the
cells starting with the letters "wo". There are more letters and numbers
after the letters "wo". I need to count the cells that start with the
lettes "wo". What is the function and format of the command to count the
cells on my spreadsheet with the letters "wo"?