Adding the cell if text is contained within

B

Bizzy

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.
 
J

JLatham

=COUNTIF(C:C,"x")
in any column OTHER than C, or if your data goes from Row 1 to 141 and you
want a count in C142, then in C142:
=COUNTIF(C1:C141,"x")
 
Top