I would like to have two cells displayed. One cell is an input. A user types in a number presses enter and the cell above it (displaying running tally) adds the number inputed to the number it is already displaying, and then the input cell is cleared and made ready for a new number. Is it possible and if so how?

More info if needed: it is for a timesheet. various categories will be displayed. Under the category name will the the total hours spent working in that category (the tally cell) and a cell below that is where additional time is inputed and then added to the total. I don't want to have long columns of time in each category that is then added up and displayed in the tally cell. If that can be avoided.

thanks for the help