View original (French)

Excel: sum of "yes" values

Solved
berzi Posted messages 96 Status Membre -  
 LuLi -
Hello everyone,

Could someone explain to me how it is possible in a column containing "yes" and "no" to only have the total of the yes in a designated cell?

Thank you in advance for your responses :)

Berzi

Configuration: Windows XP / Firefox 3.6.6

3 réponses

Réponse 1 / 3
ladameblanche Posted messages 318 Registration date   Status Membre Last intervention   89
 
Hello,

Here is the formula =COUNTIF(B1:B4,"yes") if B1:B4 represents the range to count.
77
laurence
 
Thank you very much!!!!!
0
Débutant
 
You're welcome :)
0
LuLi
 
Thank you very much!
0