Aggregate Excel Functions
from ironxl import *

# Load existing spreadsheet
workbook = WorkBook.Load("sample.xls")
worksheet = workbook.WorkSheets[0]

# Get range from the worksheet
selected_range = worksheet["A1:A8"]

# Apply sum of all numeric cells within the range
sum_ = selected_range.Sum()

# Apply average value of all numeric cells within the range
avg = selected_range.Avg()

# Identify maximum value of all numeric cells within the range
max_ = selected_range.Max()

# Identify minimum value of all numeric cells within the range
min_ = selected_range.Min()
pip install ironxl
Aggregate Excel Functions

Aggregate Excel Functions

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

Ready to Get Started?

Version:2026.11just released

Free pip Download