Dec 16 2021 02:30 AM
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 :)
Dec 16 2021 02:39 AM
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
Dec 16 2021 02:52 AM
@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.
Dec 16 2021 03:00 AM
@martshu Please send this excel file (a few sample rows) I will paste the formula there.
Countifs() will surely work.
Thanks
Tauqeer
Dec 16 2021 04:00 AM
@martshu I would use SUMPRODUCT. See attached.