View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stefi
 
Posts: n/a
Default count for empty cells

E.g. in range B1:B10
=COUNTIF(B1:B10,"")

Regards,
Stefi

€˛tikchye_oldLearner57€¯ ezt Ć*rta:

hello community

can anyone in community tell me whether is there a function to count for
"empty" cells beside the Count (counting cells that has numeric data) and
CountA (counting of cells that had filled alphanumeric data)

thanks again for helping
--
oldLearner57