<div>
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.
</div>


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.

<div>
To John&quot;s point, the cells that are part of the sum, must be formatted as number.
</div>


To John"s point, the cells that are part of the sum, must be formatted as number.

<div>
Thanks you. I made the column bigger and it works now.
</div>


Thanks you. I made the column bigger and it works now.

<div>
The chosen answer resolved the question.
</div>


<div>
<div class="content wysiwyg-content">
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. <br />
Windows 7<br />
Office 365<br />
Excel
</div>
</div>


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
Excel

How to get consistent results with autosum in MS excel

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.