Adding the cell if text is contained within
 

=COUNTIF(C2:C19,"x")
Counts all x's in the range from C2 to C19 - edit as necessary.


"Bizzy" wrote:

I cannot recall how to add a column that contains text.
For example if column 'C' contains 'x' I would like the bottom to add it if
it contains an 'x' only.