"Herbert Seidenberg" wrote in message
oups.com...
Assuming you want to keep entering data into the same,
single cell and not create a column of data
and you are desperate for a solution
and not afraid of iterate...
in
3
sum
12
count
4
avg_in
3
option
3
reset
1
lock
1
Name the cells as shown.
Set iterate to 1.
Create three option buttons,
label them Reset, Set and Lock
and link them to the cell <option.
Into the <sum, <count, <avg_in, <reset and <lock cell,
enter these formulas respectively
=IF(lock=1,sum,(sum+in)*reset)
=IF(lock=1,count,(count+1)*reset)
=IF(reset=0,0,sum/count)
=IF(option=1,0,1)
=IF(option=3,1,0)
Start by clicking the Reset button and
entering a number into <in.
Click the Set button and verify that you got the desired results.
Keep entering more numbers into <in or stop and click the Lock button.
If you do not Lock it, any other recalculation on the sheet
will keep adding the last value of <in.
Always enter a new number into <in before clicking Set.

I think it's time that I admitted defeat and went back to having hundreds of
columns across a row, because most of what has been said here went
completely over my head - and I didn't even have to duck!
Sorry guys, it probably sounds as simple as eating to you - but to me it
sounds so complicated as to be scary enough to make me wish I'd never asked.
Time to crawl back into my cave I think.
Dave