Using that "trick" you showed me Gord (<Shift <F8), I got 236 cells to
work before the "Formula Too Long" error popped up.

BTW, it (<Shift <F8) also works well for selecting non-contiguous cells
for the "Named Range" data entry procedure.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Niek

Using =AVERAGE((cell1,cell2,cell3............))

I quit adding non-contiguous cells at 100 and no problem to that point.


Gord Dibben MS Excel MVP

On Mon, 17 Aug 2009 15:07:10 +0200, "Niek Otten"
wrote:

And if you just put an extra pair of brackets around the list of cells, it
is considered one argument. I don't know how many cells you can put in a
list like this, but certainly more than 30. And of course then you can
start
a new list, which will only be the second argument, etc