View original (French)

Nb.IF "neither ..., nor ..., nor ..."

Solved
VicRoll Posted messages 2 Status Member -  
VicRoll Posted messages 2 Status Member -
Hello everyone and thanks in advance to those who take the time to respond to me.
Everything is in my screenshot. Don't hesitate if you need more details.

Obviously, my formula attempt doesn't work but it should help you understand the spirit of what I want to do.

Note: The letters A, B, etc. in my spreadsheet symbolize text (not numbers).

3 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    You can write like this

    =COUNT(B6:B19)-(COUNTIF(B6:B19,"A")+COUNTIF(B6:B19,"B"))

    or even
    =COUNTIF(B6:B19,"<>")-(COUNTIF(B6:B19,"A")+COUNTIF(B6:B19,"B"))

    A+
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
  2. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,

    you can also count the values and subtract each series

    =COUNTA(B6:B19)-COUNTIF(B6:B19,"A")-COUNTIF(B6:B19,"B")
    or
    =COUNTIF(B6:B19,"<>")-COUNTIF(B6:B19,"A")-COUNTIF(B6:B19,"B")

    --
    A+
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
  3. VicRoll Posted messages 2 Status Member
     
    Thank you very much!!! It works very well!
    0