View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default Counting mixed formats in a column

If your data is in column A then use this in cell B1
=COUNTA(A:A)

"RC" wrote:

I have one column of date. In it is data of the type -
12345
15689
12458A
C55897
and some blank cells.

I want to count the number of cells that are not blank whatever they contain
(i.e. whether they are pure numbers or text/numbers or numbers/text.
Can you provide a formula for this.

Thanks