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. If
I change it to =0 it sees all blank cells within N1:N35000 as 0.

How can I avoid this????

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200901/1