Why is Excel not showing the SUM in the status bar at the bottom of Excel?
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
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
Transcript of the video:
Why is sum not showing in the status bar? Oh, there's a lot of reasons.
If you have just one number of the status bar, statistics don't appear.
Or you might have selected everything that is text numbers, then you get just a count, no sum.
Come here to this little dropdown and say, "Convert to number".
Then the sums appear. The other one that's really common.
You have one or more cells in the middle that are an error. You get a count, numerical count, but no sum.
You need to go find where the error is. I hold on the shift key and page down, page down.
See, I still have a sum there, page down.
As soon as the sum disappears, then I just press the up arrow until I find the offending cell right there.
Oh, N/A, should be a zero. And the sum comes back.
It's possible that some evil person turned off the sum.
Right click, you can turn it off. You could turn all of them.
It's also possible that someone hid the status bar with Control-Shift-F1, but you'll notice that the ribbon is missing as well. Press Control-Shift-F1 to get it back.
If you have just one number of the status bar, statistics don't appear.
Or you might have selected everything that is text numbers, then you get just a count, no sum.
Come here to this little dropdown and say, "Convert to number".
Then the sums appear. The other one that's really common.
You have one or more cells in the middle that are an error. You get a count, numerical count, but no sum.
You need to go find where the error is. I hold on the shift key and page down, page down.
See, I still have a sum there, page down.
As soon as the sum disappears, then I just press the up arrow until I find the offending cell right there.
Oh, N/A, should be a zero. And the sum comes back.
It's possible that some evil person turned off the sum.
Right click, you can turn it off. You could turn all of them.
It's also possible that someone hid the status bar with Control-Shift-F1, but you'll notice that the ribbon is missing as well. Press Control-Shift-F1 to get it back.
