Hi, i created a spreadsheet that i use to record my employees records for payroll. I enter the hours worked for the week then send a copy to my accountant where he documents the information. After that i delete the hours i entered so that it's once again blank and i can enter the hours for the next week. So basically all i do is enter the info, send it to my accountant, then erase and start over the next week. This works fine for what i need it for however i would like to be able to track the total hours each employee works per year. So is there a formula i can use to keep adding up those hours even if i erase the hours again after i sent it to my accountant? Basically it would take the sum of that cell everytime i enter the hours then retain the number and add it to the next total i enter even if the first total is no longer there. Anyone with ideas let me know. Thanks!!