The fastest way to perform a calculation on a range of cells is by using the AutoCalculate feature. And the best part is, you don’t even have to type in a formula – it’s automatic! Whenever you highlight a range the cells, the sum of that range is displayed in the status bar.
However, you aren’t only limited to the SUM function. You can also calculate the Average, Count, Count Nums, Maximum, and Minimum of the range simply by right clicking on the Status Bar and choosing the desired function.
To Use the AutoCalculate Feature
- Select the range of cells you wish to calculate.
- Right-click on the Status Bar to choose another function type and click the box next to the function you want to display.
- See result in the status bar.
Similar Posts:
- Counting Blank Cells in Excel
- Counting Cells with Values in Excel
- Counting Cells with Numbers and Text in Excel
- Using the AutoSum Button in Excel
- Using the Min, Max, Count and Average Functions in Excel
- Entering in Functions Manually in Excel
- Calculating the Number of Hours between Two Times in Excel
