Hi,

Even shorter formula is just =COUNTIF(A1:A100,"*")

Dave

"Ken" wrote:

Excel2003 ... My Range contains "Date" values & various "Text" values ... I
wish a formula to count the "Text" values only.

01/01/09
01/02/09
H
01/04/09
V
01/06/09
01/07/09
01/08/09
O/S
01/10/09

Formula should return ... 3

Thanks ... Kha