The code example above shows how to retrieve aggregate values from a range of cells in an Excel spreadsheet using IronXL for Python. Note that any non-numerical cell in the selected range will be excluded from the calculation.
Sum
The Sum() method returns the total sum of all numeric values in the selected range of cells.
Average
The Average() method returns the arithmetic mean of all numeric values in the selected range of cells.
Minimum
The Min() method returns the smallest numeric value among the cells in the selected range.
Maximum
The Max() method returns the largest numeric value among the cells in the selected range.
For greater flexibility, all of the above functions can also be applied to individual rows or columns. Learn more about selecting rows and columns.
Explore Math Functions in Excel Using Python
