The "double minus" simply converts TRUE and FALSE values to 1 and 0, so the
SUM function adds up all the TRUEs in the array; that is, it counts up the
number of matches.

--

Vasant




"joebogey" wrote in message
...
I tried that and it worked perfectly. I was just wondering if you could
give
an explanation of exactly how this is working, such as what the "--" does
to
the formula?

Sorry, once I implement this I'll probably have to explain how it works.

Thanks for your help, I really appreciate it.
Joe

"Vasant Nanavati" wrote:

I'm assuming you mean:

=COUNTIF(C$1:C$15000,C1)

Try instead:

=SUM(--(C1=C$1:C$15000))

entered as an array formula with <Ctrl <Shift <Enter.

--

Vasant