Forum Discussion

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

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

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