SUMPRODUCT with OR function

[The_Rock]

Hi Guys
I've got a sumproduct formula, and saw from another post how to add in an OR function.
Its working but what I need it to do is to exclude if it meets the OR function:

=SUMPRODUCT((rABReseller="Non-AB Reseller")*(EPP_Rev_Strm="New Lic")*(EPP_PA="PA")*(ISNUMBER(MATCH(N10:N54,{"Unassigned","To Be Assigned"})))*EM_PP)

So in the above, if it is "Unassigned" or "To Be Assigned", it should be excluded from the calculation.

Ta

 

[The_Rock]

No, not at all. All idea's are good idea's

 

[The_Rock]

I've managed to get it working:

=SUMPRODUCT((rABReseller="Non-AB Reseller")*(EPP_Rev_Strm="New Lic")*(EPP_PA="PA")*(ISNA(MATCH(N10:N54,{"Unassigned","To Be Assigned",0})))*EM_PP)

Changes
1. I substituted ISNUMBER for ISNA (or ISERROR)
2. Hoggle, you were very close. The ",0" had to go inside the {}.