- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Displaying Calculations with the Status Bar
You can simplify your work using the Status bar calculations when you don’t want to insert a formula, but you want to quickly see the results of a simple calculation. The Status bar automatically displays the sum, average, maximum, minimum, or count of the selected values. The Status bar results do not appear on the worksheet when printed but are useful for giving you quick answers while you work. If a cell contains text, it’s ignored, except when you select the Count option.
Calculate a Range Automatically
- Select the range of cells you want to calculate.
- The sum, average, and count of the selected cells appears on the status bar by default.
- If you want to change the type of calculations that appear on the Status bar, right-click anywhere on the Status bar to display a shortcut menu.
The shortcut menu displays all the available status information you can track. The right side of the menu displays the current values for the different calculations.
Click to toggle (on or off) the available types of calculations.
- Numerical Count