Hi,

Glad I could help

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"tmax" wrote in message
...
The first one did not work, the second one kind of worked, but did also
count
the empty cells, which I forgot to mention where there.

So here is how i adjusted it and it works, thank you ver much!!! For your
help!!!


=SUMPRODUCT(1*(1*(P$10:P$1006)0.4),1*(1*(P$10:P$1 006)<10))

:-)