THE Auto Sum on Microsoft Spread Sheets is not working

Question

So I fill in the spread sheet for my Local Food bank but when I try to use the Auto SUM it does nothing.

Answer 1

Hello wendy hildyard

Thank you for reaching out to Microsoft Q&A forum

I can see that AutoSum is not doing anything in your spreadsheet when you use it, here are a few things to check:

• Make sure you select an empty cell directly below the column of numbers or to the right of the row of numbers, then choose AutoSum and press Enter. AutoSum works best when the numbers are in one continuous range.
• If there is a blank row or blank column in the middle of the numbers, AutoSum may stop at that gap instead of including all the values.
• If a formula appears but the total does not update, check whether Excel is set to Manual calculation. Changing calculation mode to Automatic can resolve that. Here is how to change it:
  • Select File > Options > Formulas. Under Workbook Calculation, select Automatic.
• If the cells look like numbers but were entered as text, the SUM function may ignore them.

If the issue continues, please feel free to let me know whether AutoSum inserts a formula like =SUM(...) or whether nothing appears at all, because that will help me better identify the cause.