counting a piece of a text string


Posted by jason on October 05, 1999 1:59 PM

i have an excel column that has a string of information about cds. if the cd is recorded live, if it is part of a 2 cd set, etc. sometimes it is more than one, and i type both into the box. is there a way to go through and count all the cells that contain the text string "live" if it isn't the only thing in the cell and return a total?

Thanks,

Jason



Posted by Ivan Moala on October 06, 1999 2:10 AM

Jason use this formula to do it
Assuming the range of text = B8:C14

=COUNTIF(B8:C14,"=*Live*")


Regards

Ivan