Absolutely, definitely, no. FILTER would be far more efficient. Only one cell is being calculated, albeit with 10K rows. What might be a better question is countif better/worse than MATCH. I'll check that out when I'm next at a PC.