How to COUNTIF blank cells?

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

=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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > How do I COUNTIF blank cells. Format of cell is Genera
>
>
>