Excel Office 365 Status Bar not displaying sum and average.

Question

After highlighting the numbers in my Excel worksheet, the status bar is not displaying the sum and average.

I've tried all the following and still the status bar is not functioning properly:

 1. Is the status bar showing? Yes.

 2. Is the status bar display settings selected properly? Yes, average and count are both check marked.

 3. Are the numbers formatted correctly?  Yes, they are formatted as numbers.  

 4. Did I recently install Office 365? Yes several weeks ago, problem appeared a week or so later. 

 5. Change to Excel.old? I tried doing the C:\Users(enter user name)\AppData\Roaming\Microsoft\Excel then changing Excel to Excel.old. Did not work. 

See highlighted section below:

This is a very frustrating problem since I used this function quite often for work.  Please help.

Answer 1

Dear BB2019,

Thanks for participating in the Microsoft Community. I'm an Independent Advisor and I'll help you.

Does this issue happen with a specific Workbook or with all? For instance, if you create a new workbook and type some values in 3 cells with change anything in format, Does happen the same?

In this functionality situation, you could try to repair your Office installation with this Microsoft support process:

https://support.office.com/en-us/article/repair...

Do not hesitate to ask if you need more information.

I hope it has been useful to you.

Regards,

Renzo.

Answer 2

Happens to all workbooks...

Answer 3

well yes, try with an Office Online repair.

Answer 4

Wait, first do this:

Other troubleshooting is, right-click over Status Bar, you will see if "SUM" and "AVERAGE" are selected, if is not, select it.

Answer 5

Online office repair does not have office 365 as an option plus I can't download/uninstall software easily since I'm on a work computer. 

Also, I've mentioned in point point 2 that both are selected.  If you are talking about something else please let me know.