Dates & Text?
 

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

Dates & Text?
 

=COUNTA(A1:A100)-COUNT(A1:A100)
--
Gary''s Student - gsnu200829


"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

Dates & Text?
 

One way

=COUNTA(A1:A10)-COUNT(A1:A10)

Mike

"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

Dates & Text?
 

HI Ken
Try this one also works: =SUMPRODUCT(ISTEXT(A10:A19)+0)
HTH
John
"Ken" wrote in message
...
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

Dates & Text?
 

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

Dates & Text?
 

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

Dates & Text?
 

Board ... Previously, I may have been writing this incorrectly ... :(

What I want for a returned value is:

The NETWORKDAYS ... between TODAY & 01/01/09 ... excluding any DAYs with
TEXT Codes (that are not WEEKENDS).

Thanks ... Kha




"Ken" wrote:

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