Images are reused AI-generated editorial illustrations, not documentary photographs or verified product screenshots.
Excel counting formulas answer different questions. COUNT, COUNTA and COUNTIF are not interchangeable ways to measure completed records. Choose the function according to what qualifies, then verify blanks, text and zero values so a dashboard does not present a count with an unexplained denominator.
Distinguish numeric cells from nonempty cells
COUNT counts numeric values under its argument rules; COUNTA counts nonempty cells. In a range, a number stored as text may not behave like a numeric value for COUNT. A formula returning an empty string can also behave differently from a truly empty cell. Inspect the actual data rather than relying only on visual appearance.
Use criteria when the question is conditional
COUNTIF counts cells meeting a criterion; COUNTIFS supports multiple criteria under its documented rules. Define what counts as Ready, approved or another status before writing the expression. Check spelling, wildcards and matching behavior where relevant. A nonempty note is not automatically evidence that a workflow stage is complete.
Keep the counted population explicit
Use the intended range and account for headers, added rows and filtered views. A function’s behavior should not be assumed to mean visible rows only. Document whether the report counts records, populated fields or qualifying values. Review duplicate records before interpreting a higher count as more completed work.
A practical checklist
- Define the question and qualifying population.
- Distinguish numbers from nonempty cells.
- Review empty strings and numbers stored as text.
- Use explicit criteria for status counts.
- Verify ranges, headers and duplicate records.
Worked example
Illustrative example: a four-cell range contains numeric ten, a truly blank cell, the text Ready and numeric zero. COUNT finds two numeric cells, while COUNTA finds three nonempty cells. COUNTIF for Ready finds one. These results answer different questions and should not all be labeled completed items.
Common questions
Does zero count as a number? Yes. Is an empty-looking formula cell always truly blank? No. Does counting populated cells prove valid data? No; content still needs appropriate validation.
What to do next
Name each reported count according to its real definition. A small fixture with numbers, text and blanks is an effective check before applying the formula to a client workbook.
Sources and further reading
- support.microsoft.com: count function
- support.microsoft.com: counta function
- support.microsoft.com: countifs function