how do i count the number of times a text string apears in a coloum?
Posted by Shark on August 28, 1999 12:24 AM
Posted by Ian Bartlett on August 28, 1999 1:19 AM
Posted by Ian Bartlett on August 28, 1999 1:24 AM
count cells that contain the text "no"
=countif(data,"no") not case sensitive
count cells that contain any text
=countif(data,"*")
cells containing 4 letter words
=countif(data,????")
Posted by Shark on August 28, 1999 3:48 AM
Re: but that only works if thats the only thing the cell contains
Posted by Sharl on August 28, 1999 4:26 PM
nm i got it
