I too have experienced that very same problem, but only occasionally, and as
no-one else had reported it, I assumed it was something on my machine (I do
play with quite a few things on this one). I wonder what it is? Must look
into it now that I know that you also experience it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
I've experienced some strange things using the more conventional formula:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Try this in a *new* wb:

Do not enter any data in A1:A10 yet. Enter the above formula in D1. You
get
0 which you should. Now, type an entry in A1. You get a #DIV/0! error but
you should have gotten 1. Continue to fill the range A1:A10. You will
continue to get #DIV/0! until you make an entry in A10. Now, clear the
range
A1:A10 then try filling it again. This time the formula works as expected.

I've run into something even more strange once, but I can't remember how
to
recreate it! I'm thinking this has something to do with the used range not
being set.

Biff

"Bob Phillips" wrote in message
...
That is not a limitation of arrays, 65535 is, but not 26. Must be
something
else. I tried it and added a column in BJ and it worked fine still.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Montrose77"
wrote
in message
...

I realise I'm responding to my own question, but just had the thought
to
try reducing the range, and found that if I reduce it by one column (to
26 cells) then it works as expected.

I guess that is the limit to the array size Excel can handle.


--
Montrose77

------------------------------------------------------------------------
Montrose77's Profile:
http://www.excelforum.com/member.php...o&userid=18191
View this thread:
http://www.excelforum.com/showthread...hreadid=571345