Auto Sum not working correctly

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
 
V

Vacuum Sealed

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.
Hi

Just a though, someone may have opened a file that has Auto Calculation
set to manual when opened and does not have it set back to Auto when
closing.

To check this, depending on the version you are using.

2000 - 2007.
Tools | Options | Calculation
Select Automatic.

2010
File | Options | Formulas | Calculation Options
Select Automatic.

Or if you want to keep the sheet as manual, just hit F9 to do an instant
auto-calc.

HTH
Mick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top