Counting in Columns
 

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.

Counting in Columns
 

Try something like this:

=COUNT(A1:F100)

COUNT will count numbers only. Dates are numbers.

--
Biff
Microsoft Excel MVP


"Bernie R." <Bernie wrote in message
...
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.

Counting in Columns
 

Use the COUNT function

Tyro

"Bernie R." <Bernie wrote in message
...
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.

Counting in Columns
 

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

"T. Valko" wrote:

Try something like this:

=COUNT(A1:F100)

COUNT will count numbers only. Dates are numbers.

--
Biff
Microsoft Excel MVP


"Bernie R." <Bernie wrote in message
...
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.

Counting in Columns
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Bernie R." <Bernie wrote in message
...
Thanks! Knew I was making this more complicated than it was.

"T. Valko" wrote:

Try something like this:

=COUNT(A1:F100)

COUNT will count numbers only. Dates are numbers.

--
Biff
Microsoft Excel MVP


"Bernie R." <Bernie wrote in message
...
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.