Excel negation

Bonjour,

please help me to write a formula in Excel that allows me to count the number of cells that do not contain a given character.

=COUNTIFS(Sheet1!C:C,"GIE")

thank you
Configuration: Windows XP / Safari 536.11

2 answers

  • Votes
  • Date
  • Descending date
  1. Contributor
    Hello,

    this formula should correspond to what you want:
    =COUNTA(Sheet1!C:C) -COUNTIF(Sheet1!C:C,"*GIE*")

    That is: the number of non-empty cells - the number of cells containing GIE.

    Best regards.
    --
    This guy wasn't very bright, as he was foolish.
    1. Thank you for your reply :)
    2. =NB.SI.ENS(Feuil1!C:C;"<>SNC";Feuil1!F:F;"INDUSTRIE AGROALIMANTAIRE")
    3. Contributor
      The formula should be:
      =COUNTIFS(Sheet1!C:C,"<>"SNC"",Sheet1!F:F,"agri-food industry")
    4. You're welcome :)
  2. Hello,
    Try this one if the cell contains "GIE":
    =COUNTIF(C:C,"<>*GIE*")
    1. Contributor
      Hello Morgothal,

      the formula should work, but in this case, we need to restrict the range of cells. Otherwise, the formula picks all cells that do not contain GIE, including empty cells.

      Best regards.
    2. Ah, that's right.