Thread: How to COUNTIF blank cells?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default How to COUNTIF blank cells?
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
Reply With QuoteReply With Quote