Counting Words
 

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!


--
tkinsella
------------------------------------------------------------------------
tkinsella's Profile: http://www.excelforum.com/member.php...o&userid=32960
View this thread: http://www.excelforum.com/showthread...hreadid=527867

Counting Words
 

=countif(A:A,"Complete")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"tkinsella" wrote in
message ...

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!


--
tkinsella
------------------------------------------------------------------------
tkinsella's Profile:
http://www.excelforum.com/member.php...o&userid=32960
View this thread: http://www.excelforum.com/showthread...hreadid=527867

Counting Words
 

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

=COUNTIF(A:A,"complete")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527867

Counting Words
 

Thanks! This is perfect!


--
tkinsella
------------------------------------------------------------------------
tkinsella's Profile: http://www.excelforum.com/member.php...o&userid=32960
View this thread: http://www.excelforum.com/showthread...hreadid=527867