Why doesnt union reference operator work with COUNTIF?

J

joeu2004

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?
 
D

David Hilberg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top