View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default Summing cells containing dates

One way:
=CountA(A:A)
for all of column A. Otto
"Laura" wrote in message
...
I need to add up the total number of cells in a column that contain
entries.
THe entries are dates i..e,

Column A
March 3, 2008
Feb 2, 2008
Aprril 3, 2008

June 14, 2008
(sum should = 4 for the total number of cells with entries in the column)