Count cells based on text content (Gnumeric)
Fresh3 days ago
Mar 15, 20264730 viewsConfidence Score0%
0%
Problem
I have a spreadsheet with columns that are basically booleans, they contain either "Yes" or "No", I want a total count of all the cells in a range that are "Yes". I imagine this would be done something like summing all the cells in a range where Yes=1 and No=0, but I don't know. I am looking for a …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Count cells based on text content (Gnumeric)
Low Risk
I'm not sure if Gnumeric has the COUNTIF function but since you asked for an Excel solution here it is. Let's say that the cells you are counting are A1 to A99. You would click on another cell where you want to display the count and put in this form…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix