Forum Discussion

martshu's avatar
martshu
Copper Contributor
Dec 16, 2021

Formula help

Hi all

 

I'm trying to count cells that contain either a "Yes" or a "No" across multiple columns. It is not a range (e.g., A2:A30) more D4, J4, P4, V4 and AB4 but can't seem to get the COUNT or COUNTIFS to work.  


Any help gratefully received.

 

Thanks 🙂 

excel
Formulas and Functions
office 365

4 Replies

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Dec 16, 2021

    Hi martshu 

     

    It can be done with the help of COUNTIFS() function.

    Please refer to the attached file for more understanding, where the below formula is used to count "yes" or "No".

     

    =COUNTIFS($D$3:$H$11,C13)

     

     

    Thanks

    Tauqeer

    • martshu's avatar
      martshu
      Copper Contributor
      Dec 16, 2021

      tauqeeracma - thanks for the suggestion but still can't seem to get it to work.  This is a snapshot of the workbook i need the formula for.  So I need to total up all the notes typed in a month, SaSP reviews and Support plan reviews.

       

       

Resources