Avoid counting Blank cells as "0"

[micro1000 via OfficeKB.com]

Hi I am using following formula:

=SUMPRODUCT((import!$N$1:INDEX(import!$N$1:$N$35000;COUNT(import!$A$1:$A
$35000))>0)*(import!$N$1:INDEX(import!$N$1:$N$35000;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????

 

[Jarek Kujawa]

try to exclude >0 from yr formula

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

 

[Bob Phillips]

=SUMPRODUCT(
(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(import!$A$1:$A$35000))>=0)
*(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(import!$A$1:$A$35000))<=3)
*(import!$N$1:INDEX(import!$N$1:$N$35000,COUNT(import!$A$1:$A$35000))<>""))

 

[Jarek Kujawa]

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