View original (French)

COUNT function and conditional statement

Solved
Cath- -  
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
    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- Author
      Thank you :) It worked the first time :)

      Cath :)
      0