On Sep 14, 2:56 am, Gover wrote:
"joeu2004" wrote:
And why doesn't the union reference operator work in this context?
=COUNTIF((A1:F1,M1:Z1),"=10")- Hide quoted text -

i tried this and in fact copied your formula, but the result gave me a value
error.

Yes, I know. That's why I asked the question. But now I see the
ambiguity of my phrasing in this context. You might have read it as a
sarcastic way of asking why that does not work for __you__ -- that is,
why you don't use that solution. That was not my intention. Sorry
for the confusion.