A slight wrinkle here ... I just realized that some of the cells I thought
were BLANK or EMPTY actually contain a single apostrophe ( ' ) ... which this
formula picks up as "Text" ... I need to exclude these ... I could do another
minus (-) countif, but my problem will also compound in that I have 4 non
contiguous ranges. Just kill 1 snake @ a time I guess???

Thanks ... Kha

"Dave Curtis" wrote:

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