Solved

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

Posted on 2012-04-10
8
212 Views
Last Modified: 2012-04-10
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
Comment
Question by:jlfcpa60
  • 4
  • 4
8 Comments
 
LVL 13

Expert Comment

by:Shanan212
ID: 37829783
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
 

Author Comment

by:jlfcpa60
ID: 37829816
That made a difference so what is going on with Excel?
0
 
LVL 13

Expert Comment

by:Shanan212
ID: 37829845
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
 

Author Comment

by:jlfcpa60
ID: 37829868
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 37829886
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
 

Author Comment

by:jlfcpa60
ID: 37829906
Where do I set it to automatic. I was unaware I changed it?
0
 
LVL 13

Expert Comment

by:Shanan212
ID: 37829920
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
 

Author Closing Comment

by:jlfcpa60
ID: 37829929
fast solution and I needed help fast
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
TT Column Arrange 10 28
SQL Server 2008 R2 - Updating Table/Fields Documentation 3 30
TT Status Chang 3 33
TT Master Button 18 22
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now