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