Common Errors & Fixes

• COUNTIF returns 0 or wrong count

  Causes:

  • Criteria not in quotes for text (e.g. "Yes" not Yes).
  • Data type mismatch: numbers stored as text or vice versa.
  • Extra spaces in cells; criteria does not match exactly.

  Fixes:

  • Wrap text criteria in double quotes: "Completed", ">100".
  • Use TRIM on data or match the stored format.
  • For numbers, use "=100" or ">50" as the criteria string.