jlfcpa60
asked on
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.
I am not attaching a file in the even it is a virus.
ASKER
That made a difference so what is going on with Excel?
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.
ASKER
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
sample-workbook-from-excel.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where do I set it to automatic. I was unaware I changed it?
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/
The below is for other older versions.
http://www.mdmproofing.com/iym/tutorials/excel-auto-calculation/
ASKER
fast solution and I needed help fast
lets say your column 1 is column A and column 2 is column B
for A
=sum($A:$A)
for B
=sum($B:$B)