sumproduct multiple criteria ignore error

[BYEOW1985]

Hello,

I have the following two columns in A1:B4 (customer # followed by percentage)

1 0.5
2 0.9
3 0.8
4 #DIV/0!

In column D i have a list of the customer #s. In column E i try to identify if the customer in column D have a percentage >=.8.

I am using the below formula, but getting a #DIV/0! error due to the error in cell B4, which i am not allowed to change using an iferror formula.

=SUMPRODUCT(--(A1:A4=D2),--(B1:B4>=0.8))

Is there a way to get around this using sumproduct or any other method to determine if the customer in D has a percentage >= 80%?

Thanks!

 

[Asala42]

This somewhat messy approach tests okay.

{=COUNT(IF(ISERROR(B1:B4)=FALSE,IF((A1:A4=D2)*(B1:B4>0.8),A1:A4)))}

Array formula: so hit Ctrl+Shift+Enter to get the brackets.

 

[BYEOW1985]

Thank you Asala42