count cells

[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

 

[Peo Sjoblom]

=SUMIF(B1:B4,"<>",A1:A4)


assuming that it's either a date or a blank cell

--


Regards,


Peo Sjoblom

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Oclo]

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

 

[Ashish Mathur]

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com