Hi Gord
Note: there is 255 character limit
Noted!!! See my response to Lori

SHIFT + F8 to enable "ADD" mode
had not realised that, Gord, it makes it much simpler. Many thanks.

--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Note: there is 255 character limit in the "refers to:" dialog so may
not work.

Another note: hit SHIFT + F8 to enable "ADD" mode and you do not have
to hold
CTRL key while selecting non-adjacent cells.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 15:53:34 -0000, "Roger Govier"
wrote:

Hi Tom

Create a named range for your cells to be averaged.
Select your range of cells by holding down Ctrl as you click on each
one
Enter Myrange into the Name box, (just above row Number 1 and to the
left of column A) and press Enter.

=AVERAGE(Myrange)