👻 Hunting for Blanks

Goal: Find cells that are completely empty.
COUNTBLANK ignores numbers, text, and errors. It only counts the void.

Ready...

💻 Formula Structure

=COUNTBLANK(range)
  • 1. Range: The group of cells to check.
  • Logic: Counts cells containing null or formulas returning "".
-- Find gaps in data
=COUNTBLANK( A2:A6 )
Blanks Found:
-

⚠️ Common Pitfalls

🚫 The "Space" Trap
A cell with a space " " is NOT blank. It contains text. COUNTBLANK will ignore it.
🚫 Zero is Value
A cell containing 0 is a number, not a blank. It will be ignored.
✅ Empty Strings Count
Formulas that return an empty string like =IF(A1>10, "Yes", "") ARE counted by COUNTBLANK.