View original (French)

How to sum "X" in an array?

Solved
Cakine -  
 Cakine -
Hello,

I created an attendance table with "X"s and I would like to add a total, but I can't find a formula?
This question seems simple to me but I can't find the right formula!
Help me :)
Thank you

Configuration: Windows 7 / Internet Explorer 9.0

1 answer

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    using COUNTIF: 

    =COUNTIF(range_to_test,"X")


    Best regards.
    19
    1. Cakine
       
      Thank you very much :)
      0