Counting Occurrences of data in cells

[Guest]

How do I count the occurrneces of data in cells. I have a spreadsheet with a column that contains multiple values. I want to count only the cells that start with the value of "wo" in the first two positions of the cell. Please help if you can.

 

[Frank Kabel]

Hi
one way:
=COUNTIF(A:A,"wo*")
if column A stores your data

 

[Guest]

Frank, thanks your formula worked great

Confuse


----- Frank Kabel wrote: ----

H
one way
=COUNTIF(A:A,"wo*"
if column A stores your dat

--
Regard
Frank Kabe
Frankfurt, German

Confused wrote