| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting entries in 2 columns | Excel Discussion (Misc queries) | |||
| Counting Data in Columns | Excel Discussion (Misc queries) | |||
| Counting in two columns | Excel Worksheet Functions | |||
| counting columns | Excel Worksheet Functions | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
