How do I COUNTIF blank cells. Format of cell is General

Assuming your range is A1:A10 you could use

=COUNTBLANK(A1:A10)

Formulas in your range that return "" are counted but zeros are not.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=528661

=COUNTBLANK() (Can't remember if you need analysis toolpak installed or
not)

or

=COUNTIF(Range,"")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



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

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

Try one of these:

=COUNTIF(A1:A100,"")

=COUNTBLANK(A1:A100)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Soapman" wrote:

How do I COUNTIF blank cells. Format of cell is Genera

Use COUNTBLANK()
--
Gary's Student


"Soapman" wrote:

How do I COUNTIF blank cells. Format of cell is General

Apparently not as I have never installed the analyis toolpak and countlbank
worked fine for me.
--
Kevin Vaughn


"Ken Wright" wrote:

=COUNTBLANK() (Can't remember if you need analysis toolpak installed or
not)

or

=COUNTIF(Range,"")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------



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