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 COU...
excel
Formulas and Functions
office 365
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.

 

 

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

    martshu Please send this excel file (a few sample rows) I will paste the formula there.

    Countifs() will surely work.

     

    Thanks

    Tauqeer

Resources