try to exclude 0 from yr formula

and use COUNT(import!$A$1:$A$35000) simply


On 19 Sty, 11:48, "micro1000 via OfficeKB.com" <u48676@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200901/1