Right-click the status bar and select the AutoCalculate option from the shortcut menu. (The default AutoCalculate operation is to sum the numbers.)
The status bar displays the selected calculation, for example, the lowest number in the selection (Min = $18,000.00).
INTRODUCTION
Suppose you want to see a function performed on some of your data in this example, to determine the lowest quarterly sales goal of any region in 2004 but you don't want to add the function directly into the worksheet. Excel's AutoCalculate feature can help.
TIP
Turning Off AutoCalculate
AutoCalculate continues to work until you turn it off. You can turn off the AutoCalculate feature by selecting None from the AutoCalculate shortcut menu.