Microsoft Excel Tutorial: Why is Excel not showing the SUM in the status bar at the bottom of Excel?

Welcome to my #shorts video where we'll be discussing why the SUM function may not be appearing in the status bar at the bottom of your Excel spreadsheet. As an Excel expert, I've encountered this issue many times and I'm here to share some possible reasons and solutions with you.

Firstly, if you only have one number selected in your spreadsheet, the status bar will only display a count and not a sum. This is because the statistics function is not applicable to just one number. To fix this, simply select multiple numbers or cells and the sum will appear in the status bar.

Another common reason for the SUM function not appearing is when you have selected cells that contain text instead of numbers. In this case, the status bar will only show a count and not a sum. To resolve this, go to the little dropdown menu in the status bar and select "Convert to number". This will convert all the selected cells to numbers and the sum will appear.

If you have one or more cells in the middle of your spreadsheet that contain an error, the status bar will only show a count and not a sum. To locate the error, hold down the shift key and press the page down button until the sum disappears. Then, press the up arrow until you find the cell with the error. Once you fix the error, the sum will reappear in the status bar.

It's also possible that the SUM function has been turned off by someone. To check this, right click on the status bar and make sure the "Sum" option is selected. It's also possible that the entire status bar has been hidden using the shortcut Control-Shift-F1. If this is the case, simply press the same shortcut to bring it back. I hope these tips have helped you understand why the SUM function may not be appearing in your status bar and how to fix it. Don't forget to like and subscribe for more Excel tips and tricks!

Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-on-youtube/

There are a few reasons covered in this short video.
1) You only selected a single cell
2) You've selected a range of text numbers
3) One or more error cells in the selection
4) Someone turned off the SUM

#excel
#microsoft
#exceltips
#microsoftexcel
#exceltricks
#excelhacks
#excelbug

This video answers these common search terms:
how to see status bar in excel
how to use status bar in excel
how to find status bar in excel
how to view status bar in excel
where is the status bar excel
where is the status bar in excel
where is the status bar on excel
how to get to status bar in excel
how to create a status bar in excel
how to modify the status bar in excel
how to get the customize status bar in excel
excel sum not appearing in status bar
missing sum in excel status bar
total not displaying in excel status bar
sum function not working in excel status bar
excel status bar calculation issue
troubleshooting excel status bar sum
sum not visible in excel bottom bar
excel auto sum not working in status bar

Table of Contents
(0:00) Why is sum missing from Excel status bar?
(0:10) Numbers stored as text give only count
(0:20) One or more error cells in selection
(0:40) Turned off status bar or hid it?
(0:50) Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads/1233853/