View original (French)

Error 501 libreoffice calc

norma3874 Posted messages 3 Status Member -  
yclik Posted messages 3875 Registration date   Status Member Last intervention   -
Hello,

I am a complete beginner on LibreOffice Calc and I am trying to use the COUNTIF function.
Unfortunately, the software is showing me error message 501 and I don't understand why.
I want to count the number of rows that match the criterion "Expressif".

I am attaching screenshots to show.

If anyone could help me :)

Thank you!

1 answer

  1.
    yclik Posted messages 3875 Registration date   Status Member Last intervention   1 611
     
    Bonjour
    you need a semicolon in the formula as the separator between range and criteria 
    =COUNTIF(C2:C13;"Expressif")
    0