Solved

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

Posted on 2012-04-10
8
230 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

785 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