View original (French)

COUNT function and conditional statement

Solved
Cath- Posted messages 4 Status Member -  
Cath- Posted messages 4 Status Member -
Hello,

I'm looking for how to create a COUNT function while excluding certain data.

My formula looks like this =COUNT(DR6;DR80) but I want to exclude data equal to F and C

How can I do that?

Thank you :)

1 answer

  1.
    via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    Hello

    One possibility:
    =COUNTA(DR6:DR80)-COUNTIF(DR6:DR80,"F")-COUNTIF(DR6:DR80,"C")

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. Cath- Posted messages 4 Status Member
       
      Thank you :) It worked the first time :)

      Cath :)
      0