View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default What FORMULA will count records that CONTAIN certain text?

=COUNTIF(range,criteria)

Vaya con Dios,
Chuck, CABGx3



"jfrisch3" wrote:

I have a survey that allows mulitple answers. What formula can I use to
count the records that contain certain text? I can Filter the responses for
those records that contain the data, but I want to use a formula instead.