Thread: Counting in columns
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ytayta555 ytayta555 is offline
external usenet poster
  
Posts: 247
Default Counting in columns
On 10 Iun, 15:36, Deb wrote:
*What I need to is to be able to know how many cells have dates in.

Maybe next (count and cells with text) :

=COUNTBLANK(A:A)
or : = 65536 - COUNTBLANK(A:A)
Reply With QuoteReply With Quote