View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Countif(Not blank)

Just use "<" rather than "<"""

Regards,
Fred.

"David" wrote in message
...
Trying to count cells in the indicated cell that are not blank. This is
what
I tried, but it still counts blank cells.

=(COUNTIF(AB4,"<""")+COUNTIF(AG4,"<""")+COUNTIF( AL4,"<""")+COUNTIF(AQ4,"<"""))

Thanks