IF Sumproduct function in excel to exclude blank rows

[newbie4]

I have a if sum product function that will work only if all the cells are filled in. How do I add in a formula to exclude any blank cells from the list within this function.

Please Login or Register  to view this content.

I was thinking ERROR, but not sure if that will really work. Again not all rows are filled in and the function will not work until it has all been filled in. Any help would be much appreciated.

Thank you,
Newb

[NeedForExcel]

So basically if no item in columns O & I match with O2 & I2 respectively, you want New to be displayed.. Is that so?

[FDibbins]

Hard to say without seeing what that relates to, but have you considered using sumifs instead?

Suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[:) Sixthsense :)]

It is a normal formula so no need of Array type of keyboard input


=IF(SUMPRODUCT(($O$2:$O$8818=O2)*ISNUMBER($I$2:$I$8818)*($I$2:$I$8818>I2))=0,"New","Old")

[newbie4]

**Thank you ALL!!** ISNUMBER worked perfectly...I must remember that function and use it more often. -Newb