I opened a spreadsheet that another user had created and the are two numbers in one of the columns that the AutoSum function is not including in the total. The numbers in question are included in the total if I use a formula to add, subtract, mutiply or divide them. It seams to be strictly an AutoSum problem. I have looked at the formatting of the two cells and I can not see any difference between them and the cells that are normal. I have used the Format Painter to copy the formatting from the good cells to the bad cells and there is no change. My concern is that this spreadsheet has been copied and used for other workbooks and I need to find a quick way to determine if the AutoSum function is working properly without having to manually add up all the numbers in each column. Also, does anyone know why this is happening and how I can stop it from happening? Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
AutoSum Function Problem
- Thread starter Squishie
- Start date
Todd Bardoni
Well-known Member
- Joined
- Aug 29, 2002
- Messages
- 3,042
Just formatting the cells will not work. You need to actually 'change' the cell's data. Two ways:
1. Double-click so as to enter into edit mode and hit enter for each of the cells in question (if formatted as general or number).
2. Copy a blank cell and then select the cells in question and Pastespecial/values/add.
1. Double-click so as to enter into edit mode and hit enter for each of the cells in question (if formatted as general or number).
2. Copy a blank cell and then select the cells in question and Pastespecial/values/add.
Upvote
0
