[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Excel 2007 is acting crazy, columns of different numbers summed come up with same total

I have to columns of numbers that I am summing and both come up with the same total, but the totals should not be the same as they are completely different numbers. Could this be a virus and what should I do?

I am not attaching a file in the even it is a virus.
0
jlfcpa60
Asked:
jlfcpa60
  • 4
  • 4
1 Solution
 
Shanan212Commented:
try this formula for total

lets say your column 1 is column A and column 2 is column B

for A

=sum($A:$A)

for B

=sum($B:$B)
0
 
jlfcpa60Author Commented:
That made a difference so what is going on with Excel?
0
 
Shanan212Commented:
Do not think its a virus. You may post a  sample if you wish! I am not sure how you are adding up the columns originally too.
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
jlfcpa60Author Commented:
I am attaching the workbook and you can see at the bottom where I have summed the numbers and it comes up with the same amount. It does the same thing on another  persons computer as well. The columns in question for this sample are V and W
sample-workbook-from-excel.xlsx
0
 
Shanan212Commented:
For me I am getting

for V column - the sum is
14093213      
for W column - the sum is
9964963

In the link below - the user is setting formulas to 'Manual'. Check if yours is in Manual, if so then change it to automatic
http://www.itechtalk.com/thread10208.html
0
 
jlfcpa60Author Commented:
Where do I set it to automatic. I was unaware I changed it?
0
 
Shanan212Commented:
The above link I posted is for 2007 and 2010

The below is for other older versions.
http://www.mdmproofing.com/iym/tutorials/excel-auto-calculation/
0
 
jlfcpa60Author Commented:
fast solution and I needed help fast
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now