Two checked boxes may look identical while storing values that formulas interpret differently. Before building a count or filter around a checkbox column, inspect how that column is configured.
The Google Sheets checkbox guide explains custom values, such as Yes for checked and No for unchecked. Those values matter when another formula searches for a particular result.
Make a three-row test
Create a disposable list with three fictional tasks. Configure the checkbox values, check two rows, and confirm that your summary counts two using the actual stored checked value.
Then clear one checkbox and repeat the check. This small test covers both states instead of proving only that the first display looked plausible.
Avoid mixing checkbox configurations within one column without a clear reason. A copied row from another sheet may bring a different rule, so review the validation settings when behaviour becomes inconsistent.
The label beside the checkbox matters too. “Reviewed” and “approved” describe different decisions. A tick cannot explain which decision was made unless the column and workflow do so.
Keep a short note of the checked and unchecked meanings near the working instructions. That makes the sheet easier for the next person to use and prevents a decorative tick from standing in for an undefined status.
Editorial illustration from this site’s image library; not documentary evidence of the example or object discussed.

