View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Average a column containing numbers and text

=countif(a:a,"s")
(in any cell not in column A)

Will return the number of cells in column A that contain S (that single
character).

=countif(b1:B99,"c/o")
Will return the number of cells in B1:B99 that contain c/o.

Malcolm wrote:

I need to count text cells that contain the letter S and the text C/O. Can
this be done. By the way this would be two different total cells, one for "S"
and one for "C/O".

Thanks in advance


--

Dave Peterson