Correction:

The result of the formula will give you
16711680
which is the sum of cells in 255 cols X 65,536 rows, each having a value of 1

"Sheeloo" wrote:

I don't think there is any limit...
In Excel 2003 I defined ColsBIV as
=Sheet1!$B:$IV
and then used
=SUM(ColsBIV) in A1
result was (with 1 as the value in all cells in the range B:IV
851968

which shows that name ColsBIV refers to 851968 cells



"peingle" wrote:

It appears to be the case, but I don't know what the maximun is, or if my
error is for another reason.