I risk causing some upset here but...............Ummmmm
What does that all mean Domenic? Some dumb questions to follow!!

Which cell do I name Data???

Where do I place
=Sheet1!$D$13:INDEX(Sheet1!$D$13:$D$65536,MATCH(9. 99999999999999E+307,She
et1!$D$13:$D$65536)) ????

Where do I use the formula... =AVERAGE(Data)

Perhaps I should have included the fact that I am very new to this functions
and macro stuff. A point that I am sure after this post will become painfully
obvious. LOL

"Domenic" wrote:

Define a dynamic range...

Insert Name Define

Name: Data

Refers to:
=Sheet1!$D$13:INDEX(Sheet1!$D$13:$D$65536,MATCH(9. 99999999999999E+307,She
et1!$D$13:$D$65536))

Click Ok

Then use the following formula...

=AVERAGE(Data)

Hope this helps!

In article ,
Sherry wrote:

Hello all!
I wish to obtain the average of a number of numeric cells but wish this
average to be ongoing rather than restricted to a range of cells.

For example
=AVERAGE(D13:D17) will only give the average of the cells D13 to D17 but I
will be continually adding more data and wish for this to be calculated in
the average also.

My overall objective here is to carry out evaluations on staff performance
and as each new review arrives from a client regarding a staff member, I will
be adding a new row to include this data.Therefore need to have the number of
all reviews received whether it be five or fifty to be calculated in the
overall average.

I have not been able to identify anything in the application help to cover
this use of the average function and help will be greatfully appreciated

Cheers Sherry