Solved

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

Posted on 2012-04-10
8
247 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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,…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

735 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