count blank cells?

  • Thread starter Thread starter Gregg Stone
  • Start date Start date
G

Gregg Stone

I need to count the number of blank cells in a column, including cells that
are blank but have a formula in them. Don't think I can use the COUNTA
function or COUNTBLANK function.

Anyone got any ideas?

Thanks in advance for suggestions.
 
COUNTBLANK should suffice for all cells that are truly
empty and those that are blank due to formula (where a ""
was used). If the formulas actually use " ", then use:

=COUNTBLANK(A1:A10)+COUNTIF(A1:A10,CHAR(32))

HTH
Jason
Atlanta, GA
 
COUNTBLANK should suffice for all cells that are truly
empty and those that are blank due to formula (where a ""
was used). If the formulas actually use " ", then use:

=COUNTBLANK(A1:A10)+COUNTIF(A1:A10,CHAR(32))
Click to expand...
...

Or =SUMPRODUCT(--(TRIM(A1:A10)=""))
 
Back
Top