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)