Excel does not display Sum on the taskbar, what to do?

Excel not showing Sum on the taskbar makes you feel confused and most of all, you don't know how to handle this situation? See the solution shared in TipsMake's article now!

Excel's status bar will show you the total, count, or average. But this status bar doesn't always work normally. Evidence is that many users have encountered the situation where Excel does not display Sum on the taskbar . Don't worry because you've come to the right place, TipsMake has found the cause and helped you fix this problem.

Excel does not display Sum on the taskbar, what to do? Picture 1

Causes and solutions when Excel does not display Sum

The error when dragging the mouse in Excel and not displaying the total value in the status bar does not suddenly happen. It's possible that you have incorrectly configured the taskbar display, or the number is formatted as text. Here's what you need to do to solve this problem.

Enable Sum display in status bar

The error of displaying Sum Count in Excel's Status bar is mainly because you did not choose to display these items in the status bar. Therefore, fixing this error is not difficult with the following steps:

1. At the bottom of the Excel window, the user right-clicks the status bar.
2. In the displayed context menu, select Customize Status Bar (Or in some new versions, Customize Status Bar is automatically displayed)
3. Look in the list and make sure that Sum/Count and Average are ticked.

Excel does not display Sum on the taskbar, what to do? Picture 3

Fix bug where numbers are formatted as text

The total and average will be displayed under Excel's status bar in case of numeric data. Therefore, if SUM is not displayed in the taskbar, it is likely because the numbers in the file are formatted as text. To fix this error, follow the steps below:

1. Step 1 : Select cells with text format > Click the Home tab .
2. Step 2 : Find the Format line > Click the drop-down arrow > Select Number > Then you will see the problem resolved. Note, if any data cells have a sign (') , you must delete them for the SUM to display.

Excel does not display Sum on the taskbar, what to do? Picture 4

Instructions to resolve the status bar error showing incorrect total, average and quantity

For this condition, the cause may be that the cell is hidden or filtered. So, the solution to the problem is to let the document show all hidden cells if there are any. At the same time, it is necessary to delete filters within the selected range. Because Excel may have excluded those cells from the calculation, resulting in the results displayed in the status bar being incorrect.

Some solutions when Excel does not display SUM in the status bar

In addition, SUM 'disappearing' in the status bar could also be due to technical problems due to the version of Excel you are experiencing. Therefore, you should apply the following basic solutions:

1. The simplest way is to close and restart Excel.
2. Older versions may have errors and this is also the likely 'culprit' that causes Excel's taskbar to not work properly. You should check and update Excel to the new version if available.
3. Repairing Office installation is also an effective solution to fix errors that you should not ignore.
4. Finally, if all measures fail. First, open another Excel document to check if the error is due to this Excel file itself. In the remaining cases, you should apply the method of uninstalling and reinstalling Excel for your device.

Excel does not display Sum on the taskbar, what to do? Picture 6

TipsMake has shared how to fix Excel error not displaying Sum on the taskbar. Hopefully these solutions will help you fix the error successfully. If you have other problems with Excel, don't hesitate to leave a comment for answers.

David Pac

Update 09 December 2023