How to get consistent results with autosum in MS excel

When I want to add a column of figures, sometimes autosum works and sometimes it doesn't, even though I can't see how I did anything differently. Sometimes there's no response when I click autosum. Sometimes I get hashtags (#####) but no numerical answer.
Windows 7
Office 365
Al ChristieAsked:
Who is Participating?
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
When you see ##### in a cell that means, the column width is not enough to display the cell content. Increase the column width and that will resolve your issue.
JohnBusiness Consultant (Owner)Commented:
In addition to the above, a space in a cell may cause auto sum to stop there. I use auto sum frequently but I check and change it if it is not going to work.
To John"s point, the cells that are part of the sum, must be formatted as number.
Al ChristieAuthor Commented:
Thanks you. I made the column bigger and it works now.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answer resolved the question.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.