View original (French)

EXCEL Calculate the number of YES and NO

Solved
crimimmi -  
Raymond PENTIER Posted messages 58230 Registration date   Status Contributor Last intervention   -
Hello,

I have a quick question:

In the lines, I have the names of people from A5 to A50, and in my column H5 to H50 their responses YES, NO, MAYBE.

I would like to calculate in H53 the number of YES responses in column H; in H54 the number of NO responses in column H, and in H55 the number of MAYBE responses.

I have tried many formulas, without success.

Thank you for your help.

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    in 53: 
    =COUNTIF($H$5:$H$50,"YES")

    in H54 
    =COUNTIF($H$5:$H$50,"NO")

    in H55 
    =COUNTIF($H$5:$H$50,"MAYBE")

    best regards
    123
    1. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      Hello friend Vaucluse,

      I was going to propose the same thing, but without the absolute addressing, which is less relevant.

      Best regards.
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello my friend
      blocked addressing allows you to pull the formula by only modifying the texts.
      regards
      0
    3. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      Indeed, but I thought of it after seeing your solution. So I removed mine :D
      0