View original (French)

NB IF does NOT contain

fredofredy1 Posted messages 9 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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 réponse

Réponse 1 / 1
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717
 
Hello,

e.g.:
=COUNTIF(A1:A16,"<>*TOYOTA*")
2
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717 > Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention  
 
Hello, how’s it going??

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

Thank you both so much!!
0
fredofredy1 Posted messages 9 Status Membre
 
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
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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