Common Errors & Fixes

• SUMIF returns 0 or wrong sum

  Causes:

  • Criteria not in quotes for text (e.g. "Apple" not Apple).
  • Sum_range and range different sizes; only overlapping rows are summed.
  • Number stored as text in range; criteria does not match.

  Fixes:

  • Use quotes for text: ">100", "Sales".
  • Make sum_range same size as range, or omit sum_range to sum range.
  • Align data types; use VALUE or TEXT as needed.