I have been conducting a payroll for a company for over a year now. Part of the process is developing an excel worksheet outlining the hours worked and the total gross pay for each employee. The total of this spreadsheet has to balance to my ADP register. Last week the totals would not balance. When I added the excel numbers up manually however, the totals matched. I looked again and noticed that when I selected all of the totals for the employees the sum in the bottom right corner was the same number as my total in ADP and that I calculated manually. Does anyone know why my Auto Sum Cell was not calculating correctly? All of the relevant cells were included in the formula so I am not sure why it would not work. Any suggestions are helpful.