Select a range.
The sum, average, and count of the selected cells appears on the status bar by default.
![The sum, average, and count of the selected cells appears on the status bar by default.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Calculate_Range_Automatically___The_Sum_Average_And_Count_Of_Select.PNG)
If you want to change the calculations on the Status bar, right-click anywhere on the Status bar to display a shortcut menu.
![If you want to change the calculations on the Status bar, right-click anywhere on the Status bar to display a shortcut menu.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Calculate_Range_Automatically___If_You_Want_To_Change_Calculations_.PNG)
The right side of the menu displays the current values for the different calculations.
![The right side of the menu displays the current values for the different calculations.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Calculate_Range_Automatically___The_Right_Side_Of_Menu_Displays_Cur.PNG)
Click to toggle (on or off) the available types of calculations: Average, Count, Numerical Count, Minimum, Maximum, Sum
![Click to toggle (on or off) the available types of calculations: Average, Count, Numerical Count, Minimum, Maximum, Sum](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Calculate_Range_Automatically___Click_To_Toggle_on_Or_Off_Available.PNG)