I guess it depends on what odd is?

I find it odd that 65535 elements are ok, but 65536 ain't.

===
And it's nice to note that these limits have been changed in the upcoming
version of excel. (Whole columns will be ok.)


Bob Phillips wrote:

"Dave Peterson" wrote in message
...
One way:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you
do it
correctly, excel will wrap curly brackets {} around your formula. (don't
type
them yourself.)

Adjust the range to match--but you can't use the whole column--oddly
enough, you
can use the whole row.

Not really odd, array formulae have a limit of 65535, a row can only get to
256.

--

Dave Peterson