Counting Occurrences of data in cells

C

Confused

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

confused

Frank, thanks your formula worked great :eek:

Confuse


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

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

--
Regard
Frank Kabe
Frankfurt, German

Confused wrote
 
Top