Look Who it Was Random video

Excel - Find Total of Excel Cells Without a Formula - Episode 437

231 views · Published 18 September 2009 · 1:58 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Find Total of Excel Cells Without a Formula.
 
Welcome back to the MrExcel netcast! In today's episode, we're going to explore a handy feature in Excel that allows you to add up numbers without using any formulas. That's right, you heard me correctly. No formulas needed! All you have to do is select a series of cells containing numbers and look down at the status bar. Excel will automatically show you the total of those selected numbers. It's that simple!

But wait, there's more! Did you know that you can also customize what appears in the status bar? By right-clicking on the status bar, you can choose to display the sum, average, minimum, maximum, count, or count of just the numeric values. And if you accidentally turn off the sum option, don't worry. Simply click on the area where it used to be and choose "Sum" to bring it back. It's as easy as that.

Now, if you're using Excel 2007 or later, you're in luck. The status bar feature has been greatly improved in these versions. Not only does it show the sum, average, minimum, maximum, and count, but you also have the ability to choose which items you want to see. You can even add more items to the status bar, as long as they fit. Just right-click on the status bar and select the options you want to display. It's a great way to customize your Excel experience and make your work more efficient.

I know, it's amazing how such a simple feature can make a big difference in our daily use of Excel. And the best part is, not many people know about it! So, next time you're working on a spreadsheet, remember to take advantage of the status bar and its useful features. Thanks for tuning in to this netcast from MrExcel. Don't forget to subscribe and hit that notification bell to stay updated on our latest videos. See you next time!

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

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

Table of Contents:
(00:00) Introduction to the status bar 
(00:23) Adding up numbers without formulas 
(00:33) Changing the sum to other calculations 
(00:43) Turning off the status bar feature 
(00:53) How to bring back the status bar 
(01:03) Status bar feature in Excel 2003 and 2007 
(01:13) Customizing the status bar in Excel 2007 
(01:24) New items available in the status bar 
(01:34) Improvements to the status bar feature 
(01:44) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding up numbers without formulas in Excel
Controlling status bar items in Excel
Excel 2003 vs Excel 2007 status bar features
Excel tips and tricks for status bar
How to change status bar options in Excel
Improvements to Excel status bar
Maximizing productivity with Excel status bar
MrExcel netcast on Excel status bar
New features in Excel 2007 status bar
Restoring missing status bar in Excel
Uncovering hidden features in Excel status bar
YouTube video on Excel status bar features

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



Did you ever notice the status bar below your spreadsheet? Select some numbers in Excel and the totals will appear in the status bar. In Episode 437, learn how to change the number shown in the status bar, and also the new enhancements in Excel 2007.

This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every workday to learn a tip for both versions of Excel!

More from this channel