did not think there might be any negative numbers, sorry
;-)

On 19 Sty, 12:26, "Bob Phillips" wrote:
=SUMPRODUCT(
*(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(imp ort!$A$1:$A$35000))=0)
*(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(imp ort!$A$1:$A$35000))<=3)
*(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(imp ort!$A$1:$A$35000))<""))

--
__________________________________
HTH

Bob

"micro1000 via OfficeKB.com" <u48676@uwe wrote in messagenews:9069dbda7d9d0@uwe...



Hi I am using following formula:

=SUMPRODUCT((import!$N$1:INDEX(import!$N$1:$N$3500 0;COUNT(import!$A$1:$A
$35000))0)*(import!$N$1:INDEX(import!$N$1:$N$3500 0;COUNT(import!$A$1:$A
$35000))<=3))

My problem is that 0 does not count cells with 0 but only larger than 0.