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 réponse

Réponse 1 / 1
chossette9 Posted messages 6855 Registration date   Status Contributeur Last intervention   1 313
 
Hello,

using COUNTIF: 

=COUNTIF(range_to_test,"X")


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