Formula help

New Contributor

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  

4 Replies

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)

tauqeeracma_0-1639650887626.png

 

 

Thanks

Tauqeer

@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.

 

martshu_0-1639651911984.png

 

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

Countifs() will surely work.

 

Thanks

Tauqeer

@martshu I would use SUMPRODUCT. See attached.