Thread: count cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ocl0 ocl0 is offline
external usenet poster
 
Posts: 1
Default count cells

I want to count a range of cells only if date is inserted. Example A7
=sum(a1:a4) however i want it count only the date to be the factor for
counting.

a b c

1 7/24/09 8/24/09 9/24/09

2
3 8/2/09 9/2/09 10/2/09
4 8/10/09 9/10/09 10/10/09
30 60 90

7 3 3 3