If that’s the case, you can select the cells to have Excel display some summary operations on the status bar at the bottom of the workbook window.
- [Instructor] Creating a formula in Excel takes just a few seconds, but there might be times where you want to find the sum or average of a series of numbers without saving the results in your worksheet. If that's the case, you can select the cells to have Excel display some summary operations on the Status Bar at the bottom of the workbook window. I'll show you how to do that in this movie. My sample file is the Status Bar workbook, and you can find that in the Chapter Five folder of your exercise files collection. This workbook summarizes revenue for a variety of properties and I currently have cell C2 selected.
If you look down at the Status Bar, which is in this area of the program window, where my mouse pointer is. You'll notice that there's no summary. That's because there's only one cell selected, and you can see the value there. Let's say, however, that I select cells C2 through C4. When I do, you see that the summary appears on the Status Bar. And there are three summary operations displayed, and those are Average, Count, and Sum. And those values mean exactly what you would expect they would.
You can also Control + Select a series of cells. So let's say that I click cell C9, which has the 2018 value for Atlanta, and I want to compare it with the 2017 value for Atlanta, which is in cell C5. I'll hold down the Command key, and select cell C5. Both cells are now selected, and if I look down at the Status Bar, I'll see that I have my Average, my Count, and my Sum.
If you want to change the summaries on the Status Bar, then you can do that by Control + Clicking the Status Bar. So I'll hold down the Control key, and click a blank spot on the Status Bar. That displays a shortcut menu. About two-thirds of the way down, you'll see a list of six summary operations and those are Average, Count, Numerical Count, Minimum, Maximum, and Sum. And you'll notice that Average, Count, and Sum are checked. That's because they're currently displayed. If I want to remove Count and Sum, then I can click Count, that will remove it, and then if I Control + Click the Status Bar again, and clear Sum, then I just have my Average.
I can also add any of the other summaries I want, so I'll Control + Click again, and let's say that I'll do the Maximum, so I'll click that. So now I have the Average and Maximum, and I'm able to add or replace any or all of the other summaries.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.