Counting dates in columns in a linked spreadsheet

B

Bernie R.

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).
 
T

T. Valko

Use the COUNT function to count dates (assuming they're true Excel dates).

True Excel dates are really just numbers formatted to look like dates.

A1 = 1/1/2008
A2 = text
A3 = 1/31/2008
A4 = #VALUE!
A5 = FALSE
A6 = <empty cell>

=COUNT(A1:A6) = 2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting data in columns with linked cells 4
Copy Data from One Spreadsheet to Another ?????? 5
Counting NON-Blank fields 2
Counting latest date in two columns 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Counting Dates 1
Counting Results of Formulas 1

Top