Aggregate Excel Functions
The code example above shows how to easily get aggregate values from a Range of Cells in Excel Spreadsheet. However, please note that any non-numerical cell will be left out.
Sum() returns the total sum of the selected Range of Cells.
Avg() returns the average of the selected Range of Cells.
Min() returns the minimum number among the selected Range of Cells.
Max() returns the maximum number among the selected Range of Cells.
For more flexibility, the above functions can also be applied to single/multiple row or column. Learn more about selecting row and column.