Excel 2007 : Sumproduct is including blanks

Hello
I am facing a prob with Sumproduct as it's including the blank cells in the calculation .



N.B
the blank cell in including if statement.

thank you in advance



Kindly find the attachement

Try this:

=SUMPRODUCT(($A$1:$A$5>=I6)*($A$1:$A$5<=I10)*($B$1:$B$5>1)*($B$1:$B$5<>""))

Regards

If you're only interested in numbers:
-- replace the >1 test with an ISNUMBER test.

If you need to test that the value is both numeric and >1 (ie <1 numbers are to be excluded)
-- keep the >1 test and add as ISNUMBER test

Alternatively given use of XL2007 avoid SUMPRODUCT altogether:

Please Login or Register  to view this content.