I have a column of cells that at times the user will enter the words COMPLETE in certain rows of the column at certain times. Is there any way that I can formulate a cell that will count and add up the total number of cells marked COMPLETE as the user updates this column?

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.

Thanks for the help Bob Bridges