What Is AUTOSUM In Google Sheets?
AutoSum in Google Sheets is a feature that helps users complete certain functions automatically. This feature is available in both Excel and Google sheets.
In Google sheets, we can find the AutoSum feature in the menu bar. Users can simply click on the AutoSum option and can perform mathematical calculations for the given data.
For example, consider the below table showing values in column A.
Now, let us use the AutoSum option to find the total with the help of below steps.
The steps are:
To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:A7. Next, select the cell where we want to find the result. In this example, we need to select the cell A7. Next, select AutoSum option in the menu bar and click on SUM. Select the cell range and press Enter key.
We will be able to see the result in the cell A7, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the result.
Table of contents
Key Takeaways
- AutoSum feature in Google sheets is an option used to calculate and find results without the use of functions and formulas.
- It is available in the menu bar in Google sheets.
- The AutoSum feature is available both in Excel and Google sheets.
- With the data in the spreadsheet, we can simply click on the AutoSum option or use the shortcut keys, Alt+= in the keyboard.
- Remember, AutoSum in Google sheets has primary functions like SUM, AVERAGE, COUNT, MIN and MAX function. Other functions are available in categories under the AutoSum feature.
In this article, let us learn how to use AutoSum feature in Google sheets with the help of detailed examples.
AutoSum In Google Shortcut
- AutoSum in Google sheets help users find the result of commonly used mathematical calculations without using function or formula in Google sheets.
- We can use the AutoSum icon in the menu bar or use the shortcut keys are Alt + = in the keyboard.
How To Use AutoSum In Google Sheets ?
The steps to use AutoSum in Google sheets are:
Step 1: To start with, we need to insert the data in the spreadsheet. Next, select the cell where we want to find the result.
Step 2: Next, select AutoSum option in the menu bar and click on SUM.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the active cell.
Likewise, we can use AutoSum feature in Google sheets to find the result.
Examples
Let us learn how to use AutoSum feature in Google sheets with the following examples.
Example #1 – Auto Sum With Average Function
For example, consider the below table showing name and marks in columns A and B, respectively.
Now, let us use the AutoSum option to find the average with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:B7. Next, select the cell where we want to find the result. In this example, we need to select the cell B7.
Step 2: Next, select AutoSum option in the menu bar and click on AVERAGE.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell B7, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the average marks obtained in an exam.
Example #2 – Auto Sum With MAX Function
For example, consider the below table showing region and values in columns A and B, respectively.
Now, let us use the AutoSum option to find the maximum value in the data with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:B6. Next, select the cell where we want to find the result. In this example, we need to select the cell B6.
Step 2: Next, select AutoSum option in the menu bar and click on MAX.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell B6, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the maximum value in the data.
Example #3 – Auto Sum With Min Function
Let us use the same example we used in Example 2. Consider the below table showing region and values in columns A and B, respectively.
Now, let us use the AutoSum option to find the minimum value with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:B6. Next, select the cell where we want to find the result. In this example, we need to select the cell B6.
Step 2: Next, select AutoSum option in the menu bar and click on MIN.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell B6, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the minimum value in the data.
Example #4 – Auto Sum With COUNT Function
For example, consider the below table showing product and sales in columns A and B, respectively.
Now, let us use the AutoSum option to find the count or number of values in the data with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:B6. Next, select the cell where we want to find the result. In this example, we need to select the cell B6.
Step 2: Next, select AutoSum option in the menu bar and click on COUNT.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell B6, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the result.
Example #5 – Auto Sum With SUM Function
For example, consider the below table showing sample and data in columns A and B, respectively.
Now, let us use the AutoSum option to find the total in the data with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:B7. Next, select the cell where we want to find the result. In this example, we need to select the cell B7.
Step 2: Next, select AutoSum option in the menu bar and click on SUM.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell B7, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the result.
AutoSum In Google Sheets Not Working
AutoSum in Google sheets may not work if,
- Users double clicking on the AutoSum function instead of clicking once
- Data including non-numeric values instead of numeric values
- Including errors in the formulas
Important Things To Note
- AutoSum feature is an inbuilt option in Google sheets and Excel.
- Users can use this feature to calculate SUM, COUNT, MIN, MAX and other commonly used functions in Google sheets.
- Instead of using inbuilt functions, we can use the AutoSum feature in Google sheets.
Frequently Asked Questions (FAQs)
For example, consider the below table showing values in column A.
Now, let us use the AutoSum option to find the total with the help of below steps.
The steps are:
Step 1: To start with, we need to insert the data in the spreadsheet. In this example, the data is inserted in the cell range A1:A7. Next, select the cell where we want to find the result. In this example, we need to select the cell A7.
Step 2: Next, sect AutoSum option in the menu bar and click on SUM.
Step 3: Select the cell range and press Enter key.
We will be able to see the result in the cell A7, as shown in the below image.
Likewise, we can use AutoSum feature in Google sheets to find the result.
AutoSum is used to help users find and calculate simple mathematical functions in Google sheets with using functions and formulas. Therefore, complex or advanced functions which we can use in combination are not available in Google sheets.
Yes. AutoSum works for all the data just like the functions in Google sheets. It eases our time by not using the function or formulas.
Download Template
This article must help understand the AUTOSUM In Google Sheets with its formula and examples. You can download the template here to use it instantly
Recommended Articles
Guide to What is AUTOSUM In Google Sheets. We learn its definition & how to use AUTOSUM In Google Sheets with examples. You can learn more from the following articles. –
Conditional Formatting With Formulas In Google Sheets
Leave a Reply