Forum Discussion

MarcBEDELE's avatar
MarcBEDELE
Copper Contributor
Jan 16, 2024

Counting cells with a word within

Hello 

i have a column of 20 cells

i want to count the number of cells with the word "thyroïdie" within, even if thyroïdie is included in a longer word, or even if there are other words in the cell

how can i do ? thanks

Excel
    • MarcBEDELE's avatar
      MarcBEDELE
      Copper Contributor
      Jan 16, 2024
      Autres ATCD
      Hypothyroidie, Menière, IVG
      HTA
      NON
      HTA
      Goujerot, hyper thyroïdie
      Goujerot, HTA, dyslipidémie
      Méningiome
      Hypothyroïdie, Goujerot, HTO, chir baria
      NON
      FA, SAOS, HTA
      FA, FV, HTA, VHA
      Bouveret, UGD
      Mal perfo plantaire, ESV
      PNS, césarienne
      NON
      NON
      asthme, CMV, toxidermie
      IM, appendicite, pso au CIMZIA, fausse couche
      Morton, zona
      CREST, stéatose, SAOS, RGO, coqueluche, GCAO, synoviorthèse
      Hyper thyroïdie, varicelle, HTA, bicuspidie, ESV, asthme, nodules, chondrocalcinose

      This is my column
      • MarcBEDELE's avatar
        MarcBEDELE
        Copper Contributor
        Jan 16, 2024
        this is my formula
        =NB.SI(X2:X22;"*thyroidie*")

        it puts 0

Resources