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.