count cells

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
 
P

Peo Sjoblom

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


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

--


Regards,


Peo Sjoblom
 
O

Oclo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top