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