Solved

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

Posted on 2012-04-10
8
251 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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

Independent Software Vendors: 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

Suggested Solutions

Title # Comments Views Activity
Calculating Sales Tax 13 68
create different version if file exists 1 45
Microsoft Excel - Select All Computers and Specific Applicaiton 2 26
LOOK FOR 22 32
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
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 will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

739 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