You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Oclo" wrote in message
...
Thanks,\I trieed them all but this =SUMPRODUCT(1*(LEN(A1:A4)=5)) work
thanks again.
Ocl

"Ashish Mathur" wrote:

Hi,

Try this

=SUMPRODUCT(1*(LEN(A1:A4)=5))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ocl0" wrote in message
...
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