What is AutoSum in Excel?
AutoSum in Excel, is an option in the ‘Editing’ group under the ‘Home’ menu where you can compute values automatically without having to type the entire formula.
The ‘AutoSum’ dropdown list shows you various operations that you can perform like this which are
- Sum
- Average
- Count
- Maximum
- Minimum
Where to find ‘AutoSum’ in an Excel sheet?
Click on the ‘Home’ menu and then you can find the ‘AutoSum’ option in the ‘Editing’ group towards the right side of your screen.
How to Use AutoSum in Excel?
Sum in Excel
-
- Select the cell in which you want to find the sum.
- Click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu.
- Choose ‘Sum’.
- Click on ‘AutoSum’ option.
Average in Excel
-
- Select the cell in which you want to find the average.
- Click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu.
- Choose ‘Average’.
- Click on ‘AutoSum’ option.
Count Numbers in Excel
-
-
- Select the cell in which you want to find the count.
- Click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu.
- Choose ‘Count Numbers’.
- Click on ‘AutoSum’ option.
Find Maximum Value in Excel
-
- Select the cell in which you want to find the maximum.
- Click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu.
- Choose ‘Max’.
- Click on ‘AutoSum’ option.
Find Minimum Value in Excel
-
- Select the cell in which you want to find the minimum.
- Click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu.
-
Choose ‘Min’.
Example
Phillip and Mariam are doing a Maths project on an Excel Sheet. Phillip suggested that they use the sum formula to find the sum of all the numbers of column B. Mariam said that they could find it easier using ‘AutoSum’ in Excel without entering the formula. How can she do it?
Solution
They should select the cell in which they want to find the sum and click on the AutoSum dropdown arrow from the ‘Editing’ group of ‘Home’ menu. They should then choose ‘Sum’ and click on ‘AutoSum’ option.