View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default How to COUNTIF blank cells?

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