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
|