View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Adding the cell if text is contained within

=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")


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