Tags Tags

Auto Sum not working correctly

July 19th, 2012 - 10:33 am ET by swalzy | Report spam
Help Create a new topic
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


swalzy
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Replies

#1 Vacuum Sealed
July 20th, 2012 - 08:00 am ET | Report spam
On 20/07/2012 12:33 AM, swalzy wrote:
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.
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search