Thread: Function - how to count all cells with text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Function - how to count all cells with text
On Mon, 12 Nov 2007 04:14:00 -0800, Kathrine
wrote:

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


Something like:

=SUMPRODUCT(--(ISTEXT(A1:A10)))


--ron
Reply With QuoteReply With Quote