Forum Discussion
martshu
Dec 16, 2021Copper Contributor
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...
martshu
Dec 16, 2021Copper Contributor
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.
Riny_van_Eekelen
Dec 16, 2021Platinum Contributor
martshu I would use SUMPRODUCT. See attached.