View original (French)

Count the yeses in a table

Solved
Loïc74 -  
lochap Posted messages 4 Registration date   Status Member 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 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor 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
    1. lochap Posted messages 4 Registration date   Status Member Last intervention  
       
      Thank you for your help
      This method has been bloody effective.
      0