View Single Post
  #4   Report Post  
Cutter
 
Posts: n/a
Default


Bear in mind that COUNTA(A:A) will return not only the number of cells
that contain text but also the number of cells that contain formulas.
If you have formulas returning the "" result to make your cells look
like they're blank then you won't be getting an accurate count of cells
containing text only.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=444459