My appologies George Gee
Thank You also for your interest in my problem. When first I read your post
i mistakenly thought you misunderstood my request but of course I was wrong.
Your tip is indded a valuable one and I chuckle I little now when I highligh
a column and see the Average function pop its head up in my status bar. Thank
you

"George Gee" wrote:

Sherry

An easy way that doesn't use any formula.
Right-click the Status Bar, and put a checkmark next to 'Average'.
Highlight the cells you wish to average, the average of these cells
will be displayed on the Status Bar!

George Gee



*Sherry* has posted this message:

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