Excel spreadsheet or Access database

I don't think you want to do it in Access....it would drive you crazy trying to figure it out & would require using VBA I suspect.

In Excel, I did it real quick and dirty like the following describes, but you could clean it up and make it "pretty" quite easily....this method would be good for 65,000 entries or whatever the number of rows available in a spreadsheet is.....

-> Select a cell where you want the total displayed (I chose C1)
-> Click the AutoSum button
-> chose a column where want to enter the numbers (in your case 1's) to be entered (I chose column A)
-> Click right on the column heading letter (in my case A) and the resulting formula in C1 is =SUM(A:A)
-> I froze the top row to prevent the total from scrolling off the page
-> Go to A1 and type 1 & enter....it automatically moves to A2...1 & enter again....etc.

Is that what you're looking to do?