Excel formulas vary widely in power and consistency. For instance,
CONCATENATE() doesn't accept even a single range such as A1:F1.
Contrariwise, SUMPRODUCT() has uses far beyond what Help delineates. The
various programmers over the years were obviously given some lattitude.

- David

joeu2004 wrote:
And why doesn't the union reference operator work in this context?

=COUNTIF((A1:F1,M1:Z1),10)

Yes, I know the workaround in this case: the sum of two COUNTIFs.
That's not the issue. The point is: the union reference operator
works with some functions -- e.g. IRR((A1,B1:B5,C1),7%) -- but not
with others. Why?