1
Select the cell for the SUM formula
Click the cell where you want the total sum to appear (e.g., cell D6).
Using Formulas for Calculations in Spreadsheet Blocks
Apply formulas in your Spreadsheet Block to quickly calculate totals, averages, percentages, and other values without manual entry.
Using Basic Formulas (SUM, AVERAGE, MIN, MAX)
- Learn how to use basic formulas to perform quick calculations inside your Spreadsheet block.
- Understand how to apply SUM, AVERAGE, MIN, and MAX functions to your data sets.
Steps to use basic formulas
2
Enter the SUM formula
Type =sum( and then select the range of cells you want to add together (e.g., D2:D4).
Close the bracket and press enter to display the total calculation.
3
Select the cell for the MIN formula
Click the cell where you want to find the lowest value in a range (e.g., cell D7).
4
Enter the MIN formula
Type =min( followed by the range of cells (e.g., D2:D4), then close the bracket and press enter.
5
Select the cell for the AVERAGE formula
Click the cell where you want the average value to be calculated (e.g., cell D8).
6
Enter the AVERAGE formula
Type =average( and select your range (e.g., D2:D4). Close the bracket and press enter.
7
Enter the MAX formula
To find the highest value, select your target cell and type =max( followed by the range.
Close the bracket and press enter to complete the calculation.
FAQs