Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates in columns in a linked spreadsheet
I have a spreadsheet that contains linked rows of data. Most of the data in
each column consists of dates. At the top of each column I'm using the COUNTA function to total the entries in each column. Problem that I'm having is in some columns it is counting every row in that column whether it has a date or not. I linked the spreadsheet with: =IF(Sheet1!A1="","",Sheet1!A1). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates in a spreadsheet.... | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting data columns with dates | Excel Discussion (Misc queries) | |||
Counting columns of dates | Excel Discussion (Misc queries) | |||
Counting columns and specific Dates | Excel Worksheet Functions |