View original (French)

NB IF does NOT contain

fredofredy1 Posted messages 9 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I would like to count the non-empty cells in a column that do not contain the word TOYOTA.

Could you please help me?

Configuration: Windows 7 / Firefox 42.0

1 answer

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,

    e.g.:
    =COUNTIF(A1:A16,"<>*TOYOTA*")
    2
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello everyone

      I believe that the one you are proposing, fç89 (hi), will also count the empty cells (unless I'm mistaken)

      =COUNTA(A:A)-COUNTIF(A:A,"*TOYOTA*")

      Best regards
      0
      1. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717 > Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention  
         
        Hello, how’s it going??

        I reacted too late, it was sent....
        0
    2. fredofredy1 Posted messages 9 Status Member
       
      It's working great, ;-)

      Thank you both so much!!
      0
    3. fredofredy1 Posted messages 9 Status Member
       
      By any chance,

      Would you happen to have a good tip for learning all the symbols (special characters) that you use for the formulas?
      0
    4. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Aside from traditional arithmetic operators, there aren't that many, and some adapt to certain types of formulas while others to different formulas,
      which ones bother you?
      0