How to use SUM function in Sheets
Step 1: Open Sheets from Google Workspace
On the right-hand side, you will see dots, and tap on it. Scroll it down, and you will see Google Sheets. Please open it and choose a blank page.
Step 2: Choose a cell
Click on an empty cell where you want the total to show up.
Step 3: Select the cells and enter the SUM Formula
Type =SUM(B2:B7).
Step 4: Press Enter
Press Enter, and you will get the SUM.
Example of SUM Function:
=SUM(A5:A10)
Google Sheets Function List
A function is a built-in formula in Excel that performs calculations using specified values in a set order. Excel offers many common functions to quickly compute the sum, average, count, maximum, and minimum values of a cell range. To use functions effectively, you need to understand their components and how to create arguments for calculating values and cell references.
Table of Content
- What is a Function in Google Sheets
- What Function of Google Sheets Includes
- How to Use Google Sheets Functions
- Conclusion
- FAQ’s on Function List in Google Sheets