O
ocl0
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
=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