"Pete_UK" wrote in message
oups.com...
Are you likely to want to do this 65,000 times? The usual way of doing
this is to use column A to enter your values, from A2 down. In B2 you
could have this formula:

=IF(A2="","",A2+B1)

and copy this down. Column B would then give you the cumulative
(running) total until there were no more numbers in column A. In C2 you
could have this formula to count how many entries you have in column B:

=COUNT(B2:B65536)

and in D2 you could work out the average as

=MAX(B2:B65536)/C2 (assuming you are only putting in positive values)

Alternatively, you could just put numbers in column A and this formula
in cell B2:

=AVERAGE(A2:A65536)

As you add numbers to the bottom of column A, the average automatically
adjusts. This way you automatically keep track of the numbers you have
used, and if you want a running total you can put this formula in
either A1 or B1:

=SUM(A2:A65536)

Hope this helps.

Pete

Thanks Pete
My work actually goes across in rows rather than down in columns, because I
want to keep everything visible on one screen - but in principle it is the
same.
I was hoping to have 10 entries across and then divide by 10 (easy enough)
and then replace one number with another but wanted a way of increasing the
count so as to keep the average true.
Seems it can't be done
Dave