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

Answer 1 / 1
via55 Posted messages 14387 Registration date   Status Member Last intervention   2 755
 
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
Cath- Posted messages 4 Status Member
 
Thank you :) It worked the first time :)

Cath :)
0