Take a look he

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
"Paul" wrote:

Can I format cell to accumulate whatever nos are
entered. Showing total as numbers are entered into cell.