Hi!

Empty cells or cells that contain formula blanks ( "" ) or both?

This counts both:

=COUNTBLANK(A1:E1)

This will only count the cells that contain formula blanks:

=SUMPRODUCT(--(ISTEXT(A1:E1)),--(LEN(A1:E1)=0))

Biff

"Soapman" wrote in message
...
How do I COUNTIF blank cells. Format of cell is General