=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