On Wed, 2 Apr 2008 13:33:01 -0700, Tim wrote:

I have the following formula.

COUNT(D4:D65536) which functions correctly.

a slight change

COUNT(D4:D65537) does not work.

To summarize if the range is greater than 2^16 then it seems to be
overflowing the system. The Max worksheet size is 1,048,576 rows by 16,384
columns according to the documentation so why doesn't this work and there is
a way to get it to work? Same result in Excel 2007 and 2003.

No, I think the problem is that you are referencing a cell with a row number
greater than 65536.

I suspect that the file you are working in was originally created in Excel
97-2003. If you look up at the title bar, do you see [Compatibility Mode] next
to the name?

If that is the case, you can either convert the file to the new format (Press
the Office button; select Convert) or save a copy in the new format.
--ron