Share via

Excel 365 Sum function does not recognise anything

Anonymous
2023-09-25T03:28:12+00:00

Ive got an Excel 365 online Spreadsheet that is suddenly having issues with the SUM function. It wont recognise the cells in the Sum function no matter what format they are in. And any working Sum functions break as soon as you touch them. It either just displays 0 or it stops calculating and shows whatever the last sum was with no updating from the changes in the relevant cells.

Ive tried changing the cells being calculated to numbers, currency, anything that is a number.

Ive looked at the calculations options and its set to Automatic. Ive tried changing it to manual and back again.

Ive tried downloading the spreadsheet and using the desktop version to edit it which also does not work - makes no difference.

Ive tried deleting the affected columns and recreating them. works when you first set it up then stops after that with the same problem.

Ive tried creating a whole new sheet and recreating my lists and formulas and it works for about 5 mins and then any time you try to change any of the cells, it stops working.

I shouldnt have to reinstall my windows office - its a problem that started in excel online and happens when Im on my work machine also which has a completely different install of office.

Help please.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-04T23:32:54+00:00

    Hi Myk. No that didnt help at all. I have already done all of that. Literally actioned all of it.

    The only thing I have seemed to find from my own investigation is that in some columns, if the fields references any other calculated cell it will cause the Sum function to disable even though its not a circular reference. So for example: I have a cell elsewhere in the workbook that will have D1=a1+b1+c1. Then in my column I have worksheet 2: F60=worksheet1:D1. So that it shows the result of D1 in worksheet1. This is not a circular reference. It does not reference any other cell in the column or even the worksheet. But it zacks out the Sum in that column. I found the workaround is to put the field referencing the other worksheet outside of the column and then only reference that field in the column. ie field F60=worksheet1:D1. column H sums column F and will collect F60 as well.

    I hope thats not too confusing.

    30+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-04T21:29:29+00:00

    I am having the same problem, please help..how can I contact your team to find a solution?

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-09-25T06:54:19+00:00

    Hi LeisaZoeller, thanks for coming into forums. I’m Myk and I’d be happy to help you with your question.

    I understand that you're having having trouble with the SUM functions in your Excel.

    Here's what I recommend. first check for errors in your formulas and ensure your data is formatted as numbers. Set calculation options to "Automatic." Use a compatible browser, disable extensions, you may also use a different browser.

    Hope this information helps.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below

    2 people found this answer helpful.
    0 comments