Counting in Columns

[Bernie R.]

I have columns of data comprosing of dates, "NA", and blanks. How do I count
only the dates and not the "NA"s and blanks? I pretty sure it involves
"counta" but this counts the "NA"s also.

Thought I saw something close to what I want but can't remember what
timeframe I saw it here in this forum.

Appreciate anyone's assistance.

 

[T. Valko]

Try something like this:

=COUNT(A1:F100)

COUNT will count numbers only. Dates are numbers.

 

[Tyro]

Use the COUNT function

Tyro

 

[Bernie R.]

Thanks! Knew I was making this more complicated than it was.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks! Knew I was making this more complicated than it was.