Master Excel Aggregate Functions in C#

VBC#

using IronXL;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// Get range from worksheet
var range = workSheet["A1:A8"];

// Apply sum of all numeric cells within the range
decimal sum = range.Sum();

// Apply average value of all numeric cells within the range
decimal avg = range.Avg();

// Identify maximum value of all numeric cells within the range
decimal max = range.Max();

// Identify minimum value of all numeric cells within the range
decimal min = range.Min();

Imports IronXL
Imports System.Linq

Dim workBook As WorkBook = WorkBook.Load("sample.xls")
Dim workSheet As WorkSheet = workBook.WorkSheets.First()

' Get range from worksheet
Dim range = workSheet("A1:A8")

' Apply sum of all numeric cells within the range
Dim sum As Decimal = range.Sum()

' Apply average value of all numeric cells within the range
Dim avg As Decimal = range.Avg()

' Identify maximum value of all numeric cells within the range
Dim max As Decimal = range.Max()

' Identify minimum value of all numeric cells within the range
Dim min As Decimal = range.Min()

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Master Excel Aggregate Functions in C#

The code example above shows how to easily get aggregate values from a range of cells in an Excel spreadsheet. However, please note that any non-numerical cell will be left out.

`Sum`

The method Sum() returns the total sum of the selected range of cells.

`Average`

The method Avg() returns the average of the selected range of cells.

`Minimum`

The method Min() returns the minimum number among the selected range of cells.

`Maximum`

The method Max() returns the maximum number among the selected range of cells.

For more flexibility, the above functions can also be applied to single/multiple rows or columns. Learn more about selecting rows and columns.

Explore Math Functions in Excel Using C#

View on GitHub

Ready to Get Started?

Nuget Downloads 2,280,941|Version:2026.10just released

Free NuGet Download

Total downloads: 2,280,941

View Licenses

Customer Highlight:

Developer Spotlight:

Webinars:

Start Free 30 Day Trial

Master Excel Aggregate Functions in C#

`Sum`

`Average`

`Minimum`

`Maximum`

Ready to Get Started?

Product Links

Iron Support Team

Want to deploy Iron Suite
to a live project for FREE?

What’s included?

Get your free 30-day Trial Key instantly

Complete Your Trial Key Signup

Your license key has been delivered to your inbox

Book a Free Live Demo

Your demo request is in.

Trusted by Millions of Engineers Worldwide

Now you've installed with Nuget

Your browser is now downloading

Next step: Start free 30-day Trial

Thank You