Use Ctrl + Click and select each of the cells you want to average and in the
NAME box enter a name for the selected range.

Then use the named range as the data source in your formula:

AVERAGE(NameDataRange)

FYI: Instead of using Ctrl + Click to select non-contiguous cell, turn on
ADD by pressing Shift + F8 and selecting each cell with a click.

Instead of naming the selected cells in the name box, click INSERT on the
menu, select DEFINE and enter the name of your range there.
--
Kevin Backmann


"GV" wrote:

I am trying to calculate the mean of about 70 numbers, but excell does not
seem to be doing it, it apears that the max is 30#s. can some one please tell
me how to do this, and whether there is a different formula.

Thanks
GV