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
|