Counting in Columns

  • Thread starter Thread starter Bernie R.
  • Start date Start date
B

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.
 
Try something like this:

=COUNT(A1:F100)

COUNT will count numbers only. Dates are numbers.
 
Back
Top