Countif Formula help

[Fanwood]

In column A I have a range of cells. Some contain dates and some contain just letters

In cell F I would like to show how many have a date.
In cell G I would like to show how many have the letter L

I tried using this for the date portion as an array formula:

{=SUM(IF(ISERROR(DATEVALUE(TEXT(A:A,"MM/dd/yyyy"))),0,1))}

{=COUNT(IF(ISERROR(DATEVALUE(TEXT(A:A,"MM/dd/yyyy"))),0,1))}

=COUNTIF(A:A,">1/1/1900")

But no luck.

Help is appreciated

 

[bbott]

These should both work:

=COUNTIF(A:A,">0")
=COUNTIF(A:A,"L")

Since Excel stores dates as a number, you can count the number of cells with a value greater than 0. However, if your dates are stored as text, this won't work.

 

[Fanwood]

These should both work:

=COUNTIF(A:A,">0")
=COUNTIF(A:A,"L")

Since Excel stores dates as a number, you can count the number of cells with a value greater than 0. However, if your dates are stored as text, this won't work.

Amazing! Look at me over thinking it lol

Thank you

 

[bbott]

Amazing! Look at me over thinking it lol

Thank you

You're welcome.