View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default Countif(Not blank)

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