As it seems that the N function might be unreliable, I would replace it with the double unarry operator. As for SUMPRODUCT being an array formula, that is correct but is much faster than usual array formulas ( CSE formulas)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post