View original (French)

Count the yeses in a table

Solved
Loïc74 -  
lochap Posted messages 4 Registration date   Status Membre Last intervention   -
Hello,

I need to count the number of yes in a table. However, I only want to count one yes per row, but count all of them in the columns. The range is between cells C40-H45.
This is for tracking a training program. Thank you for your help, it's quite urgent, I'm losing it.

Configuration: Windows 7 / Firefox 44.0

4 réponses

Réponse 1 / 4
michel_m Posted messages 18903 Registration date   Status Contributeur Last intervention   3 320
 
Hello
to complete the proposals from Raymond Pentier
in I40
=(COUNTIF(C40:H40,"yes")>0 )*1
in I46
=SUM(I40:I45)
--
Michel
1
lochap Posted messages 4 Registration date   Status Membre Last intervention  
 
Thank you for your help
This method has been bloody effective.
0