Counting Words

T

tkinsella

I am wanting to create a formula to count how many times the word
Complete shows up in a column. How do I do this? Thanks!
 
B

Bob Phillips

=countif(A:A,"Complete")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
D

daddylonglegs

Assuming you're just looking for cells that contain "complete" and
nothing else....

=COUNTIF(A:A,"complete")
 
Top