count blank cells?

[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.

 

[Jason Morin]

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

 

[Harlan Grove]

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))

...

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