Thread: Function - how to count all cells with text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Function - how to count all cells with text
=COUNTA(A2:A100)-COUNT(A2:A100)


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 04:14:00 -0800, Kathrine
wrote:

How can I insert a function that only counts cells with text??

Reply With QuoteReply With Quote