How to Use Math Functions in C# for Excel with IronXL

Updated: August 2, 2026

IronXL enables math aggregation functions like Sum, Avg, Min, and Max on Excel data directly in C#. Calculate totals and analyze numerical data without Interop using simple one-line methods on any cell range. Whether building financial reports, analyzing sales data, or processing scientific measurements, IronXL's built-in math functions streamline Excel automation workflows in .NET applications.

Quickstart: Perform Sum and Max in One Line with IronXL

Instantly compute aggregate values like sum and maximum from any range using IronXL. These one-line methods make it fast and easy to analyze numeric data without boilerplate code. The library handles all parsing and automatically ignores non-numeric content.

1Install IronXL with NuGet Package Manager
PM > Install-Package IronXL.Excel
```
Install-Package IronXL.Excel
```

2Copy and run this code snippet.

decimal total = workSheet["A1:A8"].Sum();
decimal maximum = workSheet["A1:A8"].Max();

decimal total = workSheet["A1:A8"].Sum();
decimal maximum = workSheet["A1:A8"].Max();

3Deploy to test on your live environment

Start using IronXL in your project today with a free trial

Minimal Workflow (5 steps)

Download the C# library for utilizing aggregate functions
Load an existing Excel file
Select the desired range, row, or column to aggregate
Invoke the available math functions such as Sum, Avg, Min, or Max
Perform further calculations based on the result

How Do I Use Aggregate Functions in Excel with C#?

When working with ranges of cells in Excel spreadsheets, you can utilize various aggregate functions to perform calculations. IronXL provides mathematical operations that mirror Excel's built-in functions, making it easy to manipulate Excel data in C# without requiring Microsoft Office installation. Here are essential methods:

The Sum() method calculates the total sum of selected cells.
The Avg() method determines the average value of selected cells.
The Min() method identifies the minimum number within selected cells.
The Max() method finds the maximum number within selected cells.

These functions are valuable tools for analyzing data and deriving meaningful insights from Excel spreadsheets. They automatically handle various numeric formats including integers, decimals, currency values, and percentages. When processing large datasets, these methods offer exceptional performance compared to manual cell iteration.

Please note: Non-numerical values will not be included in the calculation.

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"];

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

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

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

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

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"];

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

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

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

// Identify the minimum value among 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")

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

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

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

' Identify the minimum value among numeric cells within the range
Dim min As Decimal = 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")

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

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

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

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

Which Math Functions Are Available?

Beyond core aggregation functions, IronXL supports a comprehensive suite of mathematical operations that seamlessly integrate with C# Excel workflows. Each function is optimized for performance and accuracy:

The Sum() method calculates the total sum of selected cells, perfect for financial totals, inventory counts, or cumulative calculations. It efficiently processes thousands of cells while maintaining decimal precision.

The Avg() method determines the average value of selected cells, ideal for calculating mean scores, average sales figures, or statistical analysis. This function automatically excludes empty cells and non-numeric values.

The Min() method identifies the minimum number within selected cells, useful for finding lowest prices, minimum thresholds, or baseline values in data analysis.

The Max() method finds the maximum number within selected cells, essential for identifying peak values, highest scores, or upper limits in datasets.

These mathematical functions work seamlessly with IronXL's other features like cell formatting and formula support, enabling comprehensive Excel automation scenarios.

How to Calculate Sum (Total) in C#?

The Sum() method calculates the total of all numeric values in a selected range, performing the mathematical summation operation (Σ) across cells. This makes it ideal for financial totals, inventory counts, and cumulative calculations across large datasets.

Use bracket notation ["B2:B50"] to target a specific range and calculate the sum in one line:

using IronXL;

WorkBook workBook = WorkBook.Load("sales-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate total sales from range
decimal totalSales = sheet["B2:B50"].Sum();
Console.WriteLine($"Total Sales: ${totalSales:N2}");

using IronXL;

WorkBook workBook = WorkBook.Load("sales-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate total sales from range
decimal totalSales = sheet["B2:B50"].Sum();
Console.WriteLine($"Total Sales: ${totalSales:N2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sales-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate total sales from range
Dim totalSales As Decimal = sheet("B2:B50").Sum()
Console.WriteLine($"Total Sales: {totalSales:N2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sales-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate total sales from range
Dim totalSales As Decimal = sheet("B2:B50").Sum()
Console.WriteLine($"Total Sales: {totalSales:N2}")

Please note: Empty cells and non-numeric values are automatically excluded from the calculation.

How to Calculate Average in C#?

The Avg() method computes the arithmetic mean of selected cells, perfect for calculating average scores, mean sales figures, or statistical analysis across datasets.

The method returns a decimal value with full precision for accurate statistical calculations:

using IronXL;

WorkBook workBook = WorkBook.Load("student-grades.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate average grade for a student
decimal avgGrade = sheet["C2:C10"].Avg();
Console.WriteLine($"Average Grade: {avgGrade:F2}");

using IronXL;

WorkBook workBook = WorkBook.Load("student-grades.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate average grade for a student
decimal avgGrade = sheet["C2:C10"].Avg();
Console.WriteLine($"Average Grade: {avgGrade:F2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("student-grades.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate average grade for a student
Dim avgGrade As Decimal = sheet("C2:C10").Avg()
Console.WriteLine($"Average Grade: {avgGrade:F2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("student-grades.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate average grade for a student
Dim avgGrade As Decimal = sheet("C2:C10").Avg()
Console.WriteLine($"Average Grade: {avgGrade:F2}")

Please note: The average is calculated only from cells containing numeric values, automatically skipping empty or text cells.

How to Find Minimum Value in C#?

The Min() method identifies the smallest numeric value within a range. Beyond business applications like finding lowest prices or minimum thresholds, this function proves valuable in mathematical contexts such as determining lower boundaries, identifying vertices in coordinate data, or establishing baseline values for statistical analysis.

Apply Min() directly on any range to scan through hundreds of values instantly:

using IronXL;

WorkBook workBook = WorkBook.Load("product-prices.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the lowest price
decimal lowestPrice = sheet["D2:D100"].Min();
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}");

using IronXL;

WorkBook workBook = WorkBook.Load("product-prices.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the lowest price
decimal lowestPrice = sheet["D2:D100"].Min();
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("product-prices.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the lowest price
Dim lowestPrice As Decimal = sheet("D2:D100").Min()
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("product-prices.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the lowest price
Dim lowestPrice As Decimal = sheet("D2:D100").Min()
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}")

How to Find Maximum Value in C#?

The Max() method locates the largest numeric value in a range. Whether identifying peak values in business analytics, finding maximum vertices in geometric calculations, or determining upper bounds in mathematical models, this function streamlines data extremes analysis across your datasets.

Process large datasets like a full year of daily readings (E2:E365) with a single Max() call:

using IronXL;

WorkBook workBook = WorkBook.Load("temperature-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the highest temperature recorded
decimal maxTemp = sheet["E2:E365"].Max();
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F");

using IronXL;

WorkBook workBook = WorkBook.Load("temperature-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the highest temperature recorded
decimal maxTemp = sheet["E2:E365"].Max();
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("temperature-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the highest temperature recorded
Dim maxTemp As Decimal = sheet("E2:E365").Max()
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("temperature-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the highest temperature recorded
Dim maxTemp As Decimal = sheet("E2:E365").Max()
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F")

What Data Types Can I Aggregate?

These functions are valuable tools for analyzing data and deriving insights from Excel spreadsheets. IronXL's math functions support various numeric data types commonly found in Excel files:

Integers and Decimals: Standard numeric values processed with full precision
Currency Values: Monetary amounts with currency symbols correctly parsed
Percentages: Percentage values handled appropriately in calculations
Scientific Notation: Large or small numbers in scientific format supported
Date Serial Numbers: Excel's internal date representation aggregated when needed

When working with mixed data types, IronXL intelligently handles conversions and ensures accurate results. For complex scenarios involving multiple worksheets or workbooks, you can easily load and process multiple Excel files simultaneously.

Here's an example demonstrating aggregation across different numeric formats:

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

Imports IronXL

' Load workbook containing various numeric formats
Dim workBook As WorkBook = WorkBook.Load("financial-data.xlsx")
Dim salesSheet As WorkSheet = workBook.GetWorkSheet("Q4Sales")

' Calculate total revenue from currency-formatted cells
Dim totalRevenue As Decimal = salesSheet("B2:B50").Sum()
Console.WriteLine($"Total Q4 Revenue: {totalRevenue:N2}")

' Find the highest individual sale amount
Dim maxSale As Decimal = salesSheet("B2:B50").Max()
Console.WriteLine($"Largest Sale: {maxSale:N2}")

' Calculate average sale amount
Dim avgSale As Decimal = salesSheet("B2:B50").Avg()
Console.WriteLine($"Average Sale: {avgSale:N2}")

' Process percentage data (e.g., tax rates)
Dim avgTaxRate As Decimal = salesSheet("D2:D50").Avg()
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}")

Imports IronXL

' Load workbook containing various numeric formats
Dim workBook As WorkBook = WorkBook.Load("financial-data.xlsx")
Dim salesSheet As WorkSheet = workBook.GetWorkSheet("Q4Sales")

' Calculate total revenue from currency-formatted cells
Dim totalRevenue As Decimal = salesSheet("B2:B50").Sum()
Console.WriteLine($"Total Q4 Revenue: {totalRevenue:N2}")

' Find the highest individual sale amount
Dim maxSale As Decimal = salesSheet("B2:B50").Max()
Console.WriteLine($"Largest Sale: {maxSale:N2}")

' Calculate average sale amount
Dim avgSale As Decimal = salesSheet("B2:B50").Avg()
Console.WriteLine($"Average Sale: {avgSale:N2}")

' Process percentage data (e.g., tax rates)
Dim avgTaxRate As Decimal = salesSheet("D2:D50").Avg()
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}")

Can I Apply Functions to Rows and Columns?

For more flexibility, these functions can also be applied to single or multiple rows and columns. Learn more about selecting ranges including entire rows and columns. This capability is particularly useful when working with structured data requiring dimension-specific calculations.

You can apply math functions to:

Entire Columns: Calculate totals for complete data columns
Entire Rows: Aggregate values across row-based records
Multiple Ranges: Combine multiple selections for complex calculations
Named Ranges: Use named ranges for maintainable code

Here's a practical example showing row and column aggregation:

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("quarterly-report.xlsx")
Dim dataSheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate sum for entire column (e.g., all sales data)
Dim columnTotal As Decimal = dataSheet.GetColumn(1).Sum() ' Column B

' Calculate average for entire row (e.g., monthly averages)
Dim rowAverage As Decimal = dataSheet.GetRow(4).Avg() ' Row 5

' Work with multiple columns simultaneously
For col As Integer = 1 To 12 ' Columns B through M
    Dim monthlyTotal As Decimal = dataSheet.GetColumn(col).Sum()
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}")
Next

' Calculate grand total across multiple ranges
Dim q1Range = dataSheet("B2:D50")
Dim q2Range = dataSheet("E2:G50")
Dim firstHalfTotal As Decimal = q1Range.Sum() + q2Range.Sum()

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("quarterly-report.xlsx")
Dim dataSheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate sum for entire column (e.g., all sales data)
Dim columnTotal As Decimal = dataSheet.GetColumn(1).Sum() ' Column B

' Calculate average for entire row (e.g., monthly averages)
Dim rowAverage As Decimal = dataSheet.GetRow(4).Avg() ' Row 5

' Work with multiple columns simultaneously
For col As Integer = 1 To 12 ' Columns B through M
    Dim monthlyTotal As Decimal = dataSheet.GetColumn(col).Sum()
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}")
Next

' Calculate grand total across multiple ranges
Dim q1Range = dataSheet("B2:D50")
Dim q2Range = dataSheet("E2:G50")
Dim firstHalfTotal As Decimal = q1Range.Sum() + q2Range.Sum()

For advanced Excel manipulation scenarios, combine these math functions with other IronXL features like creating charts, applying conditional formatting, or exporting to different formats. This makes IronXL a comprehensive solution for Excel automation in .NET applications, whether building reporting tools, data analysis systems, or business intelligence dashboards.

Frequently Asked Questions

What is IronXL and how does it relate to C# Excel math functions?

IronXL is a library that enables the use of Excel math functions like Sum, Avg, Min, and Max directly in C#. It allows developers to perform Excel data analysis without using Interop in .NET applications.

How can I calculate the sum of a range using IronXL?

You can calculate the sum of a range in IronXL by using the `Sum()` method. For example, `decimal total = workSheet["A1:A8"].Sum();` computes the total sum of all numeric values within the specified range.

Can IronXL compute the average of selected cells in an Excel sheet?

Yes, IronXL provides an `Avg()` method to compute the average value of selected cells, ensuring you get an accurate arithmetic mean by automatically skipping non-numeric cells.

How do I find the maximum value in a range with IronXL?

To find the maximum value in a range using IronXL, you can use the `Max()` method. For instance, `decimal max = workSheet["A1:A8"].Max();` will identify the largest numeric value in the specified Excel cell range.

Does IronXL support calculations with different numeric formats?

Yes, IronXL supports various numeric formats, including integers, decimals, currency values, percentages, and even scientific notation, ensuring accurate results when using math functions.

How can I find the minimum value within a cell range using IronXL?

IronXL provides a `Min()` method to locate the smallest numeric value in a specified cell range. For example, `decimal min = workSheet["A1:A8"].Min();` will return the minimum value within that range.

What are the benefits of using IronXL for Excel automation?

IronXL streamlines Excel automation by providing simple, effective functions for data analysis, efficient handling of large datasets, and compatibility with various numeric formats, all without requiring Microsoft Excel to be installed.

Can IronXL work with entire columns or rows for aggregation?

Yes, IronXL allows aggregation of entire columns or rows using its math functions. You can calculate totals or averages for complete columns or rows, making it easy to work with structured datasets.

How do I perform calculations across multiple Excel ranges in IronXL?

IronXL allows combining multiple ranges for comprehensive calculations. By summing results from different ranges, such as `firstHalfTotal = q1Range.Sum() + q2Range.Sum();`, you can aggregate data across diverse selections.

What additional features does IronXL offer for Excel manipulation?

Apart from math functions, IronXL features capabilities like creating charts, applying conditional formatting, and exporting to various file formats, making it a versatile tool for comprehensive Excel automation.

Curtis Chau

Chat with engineering team now

Technical Writer

Curtis Chau holds a Bachelor’s degree in Computer Science (Carleton University) and specializes in front-end development with expertise in Node.js, TypeScript, JavaScript, and React. Passionate about crafting intuitive and aesthetically pleasing user interfaces, Curtis enjoys working with modern frameworks and creating well-structured, visually appealing manuals.

...