Sure, Barry. That's what the COUNTIF function is about. If your column is (say) C13, then your formula would be =COUNTIF(C13,"COMPLETE") — as simple as that. If you use A1 notation, it's just =COUNTIF($M:$M,"COMPLETE"). That's for the whole column; you can specify only part of the column in the usual way, if you want.