Excel® 2013 On Demand

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 ...